| A | B |
|---|
| auto-outline | A feature that automatically groups selected rows in Excel. |
| Validation | A feature in Excel that ensures data is entered correctly, before it is processed incorrectly. |
| collapse | To condense groups into single-row headings called outlines. |
| criterion | A condition you specify to limit which records are returned when filtering data. The plural of criterion is criteria. |
| data file | An electronic file that stores a series of records in a relatively simple format. |
| database | A comparatively complex system that can store a large amount of related data, which requires a program to be able to assess and render that data. |
| delimiter | A character that separates data entries from one another. |
| filter | A restriction that Excel uses to determine which worksheet rows to display. |
| grouping | Organizing data so it can be viewed as a collapsible and expandable outline. |
| macro | A series of steps you record that you might want to repeat frequently to save time. |
| outline | Single-row headings. |
| outline symbol | Symbols that add controls next to the row and column headings to change the view of an outlined worksheet. |
| quick format | Predefined formatting in Excel that enables you to apply an elaborate format that makes a table look sleek and professional. |
| slicer | One of the ways to filter a table so that it shows only records containing a certain object. A slicer is a selection panel that floats above a worksheet (the way a chart does). |
| subtotal | The sum of values that are grouped together. |
| table | A range of cells in a worksheet that contains related data and can be used by a lookup function. |
| AutoFilter | A built-in set of filtering capabilities. |
