| A | B |
|---|
| 3-D cell reference | Formula reference that combines specified data from multiple worksheets in a workbook |
| Absolute cell reference | Cell reference that remains constant and does not change when copied or moved to a different location |
| Active cell | Cell that is surrounded by a dark border |
| Cell | Intersection of a column and row |
| Cell pointer | Cross-shaped pointer that appears when the mouse pointer is over a cell |
| Conditional formatting | Formats applied to a range of values to identify a specific condition or variances in the range |
| Filtering | Locating and working with a subset of data in a worksheet |
| Formula | Set of instructions for calculating values in cells |
| Formula bar | Displays the content of the active cell |
| Function | Predefined formula that performs a calculation in a particular order, using specific values |
| Number | Constant value that can include numeric characters as well as arithmetic operators, decimals, and percent and currency symbols |
| PivotTable | Interactive table in which you can view and calculate data in different ways, allowing for different interpretations of the data |
| Range | Two or more contiguous cells selected in a worksheet |
| Relative cell reference | Cell reference that changes relative to the cell to which the content is being copied or moved |
| Sheet tab | Displays the name of each worksheet in the workbook |
| Slicer | Filter buttons inserted in a PivotTable for fast filtering and easy identification of how the table is filtered |
| Sparkline | A miniature chart (line, column, or win/loss) that displays in a cell and is used to show valuable information in little space |
| Text | Any combination of numbers, spaces, and non-numeric characters |
| Theme | Set of predesigned colors, fonts, and effects that can be applied to a workbook |
| Worksheet | Grid of vertical columns and horizontal rows in which data is entered |
