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.