| A | B |
|---|
| Absolute Reference | The cell reference in an Excel formula that doesn't change when you copy the formula to another cell or range. |
| Arguments | 1. Inputs such as numbers, text, cell references, or logical values - They are used in Excel functions to perform calculations. |
| AutoFilter | An Excel feature that enables you to apply a filter to a list in order to display a subset of data. |
| Fill Handle | The small, black square located in the lower-right corner of a selected cell or range that you can use to copy a value or formula to adjacent cells. |
| Filter | 1. A feature that allows you to display a subset of data in a list on a worksheet. |
| Formula Bar | 1. The long white bar above the column headings in an Excel worksheet that you can use to enter or edit cell data – this also displays the contents of the active cell. |
| Function | A predefined formula in Excel that performs a specific, built-in operation |
| Relative Reference | 1. A cell reference in a formula that automatically adjusts to the new location when you copy the formula to another cell or range. |
| Wizard | 1. An automated tool that helps you perform a task by presenting step-by-step content and organization choices. |
| Hyperlink | aA specially formatted text or graphic that, when clicked, connects you to another location (usually a Web page or Web site). |
| Merge | 1. An action that combines selected cells into a single cell. |
| Split | 1. An action that returns a merged cell back into individual cells. |
| Tab Scrolling Buttons | 1. The buttons that display to the left of the sheet tabs that enable you to move to the first, previous, next, or last worksheet in a workbook. |
| Tab split bar | 1. The gray vertical bar just left of the horizontal scroll bar that you can drag to the right to view hidden sheet tabs. |
