Sorting | Filtering |
Microsoft Excel | Worksheet |
Cell | Column |
Row | Header row |
The process of displaying only a certain set of data based on specific criteria. | The process of arranging data in a particular order, such as ascending or descending. |
A single page or tab within an Excel workbook that contains cells. | A spreadsheet program developed by Microsoft. |
A vertical group of cells identified by a letter in Excel. | The intersection of a row and column on an Excel worksheet, used to store data. |
The top row of data in a worksheet, often used to identify the column names. | A horizontal group of cells identified by a number in Excel. |
Data | Ascending order |
Descending order | Filter criteria |
Filter dropdown | Clear filter |
Auto filter | Custom filter |
Arranging data in order from smallest to largest. | The values or information that is stored within cells on an Excel worksheet. |
The specific conditions used to display a subset of data. | Arranging data in order from largest to smallest. |
Removing all filter criteria from a worksheet. | The dropdown menu in Excel that allows for filtering based on specific criteria. |
A filter created by the user to display data based on specific criteria. | A feature in Excel that automatically applies filters based on the data within the worksheet. |
Advanced filter | Sort order |
Sort criteria | Multiple sort |
The arrangement of data in either ascending or descending order based on specific criteria. | A filter used to display data based on complex criteria using multiple criteria ranges. |
The ability to sort data based on multiple criteria at the same time. | The specific conditions used to arrange data in a particular order. |