Search Header Logo

Mastering Excel Data Vocabulary

Authored by Wayground Content

Computers

10th Grade

Used 18+ times

Mastering Excel Data Vocabulary
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

18 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Fill Handle

The small square at the bottom-right corner of a selected cell or range, used to drag and autofill data or formulas.

A tool used to format cells in a spreadsheet.

A feature that allows users to merge multiple cells into one.

An option to change the color of the cell background.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Custom List

A predefined list in Excel for standard series

A user-defined list in Excel used for autofilling non-standard series (e.g., Low, Medium, High)

A list of Excel functions

A list of Excel templates

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Absolute Reference

A reference that changes when copied (e.g., A1)

A fixed cell reference that does not change when copied (e.g., $A$1)

A reference that is relative to the position of the cell

A reference that only applies to text cells

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Sort Key

The column or field used as the basis for sorting data.

A method for filtering data based on specific criteria.

A type of data analysis technique.

A visual representation of data trends.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Multi-level Sort

A sorting process based on a single column.

A sorting process based on more than one column (e.g., sort by Department, then by Last Name).

A sorting process that only sorts alphabetically.

A sorting process that ignores numerical values.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Descending Order

A sort order that arranges data from smallest to largest (e.g., A–Z or 1–100).

A sort order that arranges data from largest to smallest (e.g., Z–A or 100–1).

A sort order that arranges data in random order.

A sort order that arranges data alphabetically (e.g., A–Z).

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Sort

The process of arranging data in a specific order—ascending or descending—based on one or more columns.

A method of combining data from multiple sources into a single dataset.

The technique of analyzing data to find patterns and trends.

A way to visualize data using graphs and charts.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?