Mastering Excel Data Vocabulary

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.

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

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

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.

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.

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).

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.

Number Filter

• A filtering option that allows users to filter numerical data using conditions like greater than, less than, between, or equals.

• A tool for sorting text data alphabetically.

• A method for visualizing data trends over time.

• A feature that restricts access to sensitive information.

Criteria

• The condition(s) used to determine which data appears when a filter is applied.

• A set of rules for data entry validation.

• A method for sorting data alphabetically.

• A technique for visualizing data trends.

Autofill

• A feature in Excel that automatically fills cells with data based on a pattern or existing data in adjacent cells.

• A tool in Excel for creating charts and graphs.

• A function in Excel that calculates the sum of a range of cells.

• A setting in Excel that allows users to change the color of cells.