| A | B |
| ascending order | An arrangement in which data appears alphabetically from A to Z. |
| AutoFilter | A built-in set of filtering capabilities. |
| comparison operator | A sign, such as greater than (>) or less than (<), that is used to compare two values. |
| criteria | Specifications that allot what data type users want to use in a cell or range of cells and how users want that data used, formatted, or displayed. |
| descending order | An arrangement in which data appear alphabetically from Z to A. |
| duplicate value | Occurs when all values in a row are an exact match for all the values in another row. |
| filter | A restriction that Excel uses to determine which worksheet rows to display. |
| grouping | Organizing data so that it can be viewed as a collapsible and expandable outline. |
| outline symbols | Symbols that are used to change the view of an outlined worksheet. |
| placeholders | Important text directives specified by the author of the template to direct the user where to add specific data in specific cells within the template. |