| A | B |
|---|
| AutoFilter | A built-in set of filtering capabilities. |
| Auto-outline | A feature that automatically groups selected rows in Excel. |
| Boundary | The line between rows or columns. |
| 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. |
| Document theme | A predefined set of colors, fonts, and effects that can be applied to an entire workbook or to specific items in a workbook. |
| Effects | Something that modifies the appearance of an object. |
| Filter | A restriction that Excel uses to determine which worksheet rows to display. |
| Find command | A command to help you search for certain content. |
| Footer | Lines of text that appear at the bottom of each page. |
| Freeze | To prevent portions of a worksheet from moving on the screen. |
| Gridlines | The lines that display around worksheet cells. |
| Grouping | Organizing data so it can be viewed as a collapsible and expandable outline. |
| Header | A line of text that appears at the top of each page of a printed worksheet. |
| Hide | To make a worksheet invisible. |
| Macro | A series of steps you record that you might want to repeat frequently to save time. |
| Orientation | The position of the content in a worksheet, so that it prints either vertically or horizontally on a page. |
| 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. |
| Page Break | A divider that breaks a worksheet into separate pages for printing. |
| Page Break Preview | An Excel view in which you can quickly adjust automatic page breaks to achieve a more desirable printed document. |
| Pane | A portion of a divided window. |
| Parse | To separate into components. Also, to interpret character by character. |
| Quick format | Predefined formatting in Excel that enables you to apply an elaborate format that makes a table look sleek and professional. |
| Replace command | An Excel feature that allows you to add content to a text box and replace any matches Excel finds. |
| Scaling | Shrinking or stretching printed output to a percentage of its actual size. |
| Slicer | One of the ways to filter a table so that it shows only records containing a certain object. |
| 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. |
| Transposing | Changes your cell data to change orientation. |
| Unhide | To make a worksheet visible again. |
| Validation | A feature in Excel that ensures data is entered correctly, before it is processed incorrectly. |
| Watermark | Text or a picture that appears in the background of a document; it is similar to a sheet background in Excel. |
| White space | The empty area of a document in which no content appears. |
