| A | B |
|---|
| Absolute cell reference | The cell reference does not change when you copy the formula. |
| Argument | A variable or constant input needed to complete a function. |
| AVERAGE function | Calculates the arithmetic mean |
| Breakpoint | The lowest value for a specific category or series in a lookup table. |
| Circular reference | Formula contains a direct or indirect reference to the cell containing the formula. |
| Column index number | VLOOKUP function argument that identifies which lookup table column from which to return a value. |
| COUNT function | Tallies the number of cells in a range that contain number or date values. |
| COUNTA function | Tallies the number of cells in a range that are not blank. |
| COUNTBLANK function | Tallies the number of cells in a range that are blank. |
| Formula AutoComplete | Displays list of functions and defined names that match letters as you type a formula. |
| Function | Predefined computation that simplifies creating a complex calculation. |
| Function ScreenTip | Pop-up description that displays the arguments for a function as you enter it. |
| HLOOKUP | Looks up a value in a horizontal lookup table. |
| IF function | Evaluates a condition and returns one value if true and a different value if false. |
| Logical test | An expression that evaluates to true or false. |
| Mixed cell reference | Contains both an absolute and a relative cell reference in a formula. |
| Nested function | Contains another function embedded inside one or more arguments. |
| NOW function | Display the current date and time in a cell. |
| Nper | The number of payment periods over the life of the loan. |
| PMT function | Calculates the periodic payment for a loan with a fixed interest rate and fixed term. |
| Pv | The present value of the loan or an annuity. |
| Range name | A word or string of characters assigned to one or more cells. |
| Rate | The percentage of interest paid for each payment period |
| Relative cell reference | The cell reference changes when the formula is copied. |
| Semi-selection | Pointing to select cells while building a formula. |
| Table array | A range containing a lookup table. |
| TODAY function | Displays the current date in a cell. |
| VLOOKUP function | Looks up a value and returns a related result from the lookup table. |
