| A | B |
|---|
| named range | a group of cells that have a name assigned to them |
| label | cell entry made up of letters; symbols; and non-math numbers |
| value | a cell entry that consists of numbers you can do math with |
| formula | a mathematical equation entered into a cell |
| function | a "predefined" formula |
| contiguous | joined; touching; next to |
| argument | inputs such as numbers, text, cell references, or logical values used in a function to perform calculations |
| syntax | the structure for entering functions and commands, including spelling, punctuation, spacing, and acceptable keywords |
| wizard | an automated tool that helps you perform a task by presenting step-by-step content and organization choices |
| 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 |
| relative cell address/reference | a cell reference in a formula that automatically adjusts to the new location (changes) when you copy the formula to a new cell |
| absolute cell address/reference | a cell reference in a formula that doesn't change when you copy the formula to another cell |
| $ | the symbol used to create an absolute cell address/reference |
| 3D cell reference | a reference to a cell in another worksheet within a workbook that includes the sheet name as part of the reference |
| hyperlink | a specially formatted text or graphic that, when clicked, connects you to another location |
| merge | an action that combines selected cells into a single cell |
| split | an action that returns a merged cell back into individual cells |
| print titles | repeated row or column labels that appear on each page of a printed worksheet |
| freeze panes | an Excel feature that enables you to freeze rows and columns that are above and to the left of the selected cell so that they remain fixed while scrolling the worksheet |
| auto filter | a feature that enables you to apply a filter to a list in order to display a subset of data |
