| A | B |
|---|
| Cel reference | The column letter and row number used to identify a cell, such as B3 |
| Absolute cell reference | Using dollar signs in a cell reference to freeze its location in a formula to be copied |
| Value | Numeric data stored in a cell that can be used in calculations |
| Label | Text stored in a cell that cannot be used in calculations |
| Fill handle | The solid square in the lower-right corner of a selected cell used to copy the contents |
| Relational operators | Used to compare two values. They include =, <, >, etc. |
| Data series | Highlighted cells used to create Excel charts |
| Worksheet | Sheets in an Excel workbook used to organize data |
| Formula bar | Area near the top of a worksheet window that displays the contents of the active cell |
| Range | Selection of two or more cells |
| PMT function | A function that calculates a fixed monthly payment for an insallment loan |
| IF function | Function that performs an action based on a comparison |
| Merge and center | Excel command that combines cells over a selected area and centers text within a designated area |
| F4 Key | A shortcut to placing dollar signs in front of column letter and row number in a cell reference |
| Ascending sort | To arrange data in alphabetical order or numbers from lowest to highest |
| Conditional formatting | Formatting that changes the look of cells to meet a specific condition based on criteria you specify |
| Filter | A tool to screen records by identifying criteria that must be met before the records are included |
| Filter arrow | An arrow that appears in a column heading cell that opens the Auto Filter menu |
| Axis | A horizontal or vertical line that establishes the relationship between the data in a chart |
| Chart layout | An arrangement that specifies which elements are included in a chart and where they are placed. |
| Column chart | A chart that displays bars of varying heights to illustrate values in a worksheet |
| Pie chart | A chart that displays data in circular format |
| Sparkline | A mini chart that can be inserted into a single cell |
