Mastering Excel Data Vocabulary

Front

Autofill

Back

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

Front

Fill Handle

Back

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

Front

Custom List

Back

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

Front

Filter

Back

A tool that allows users to display only the rows that meet specific criteria, hiding the others temporarily.

Front

Criteria

Back

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

Front

Number Filter

Back

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

Front

Sort

Back

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

Front

Ascending Order

Back

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

Front

Descending Order

Back

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

Front

Multi-level Sort

Back

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