| A | B |
|---|
| absolute reference | A cell reference that remains fixed when the cell formula is copied to a new location. |
| argument | The numbers, text, or cell references used by the function to return a value. |
| AutoFill | A feature that copies content (text, values, or formulas) and formats from a cell or range into an adjacent cell or range. |
| constant | A value in a formula that doesn’t change. |
| COUNT function | The Excel function that tallies how many cells in specified range contain numbers or dates. |
| COUNTA function | A function that tallies how many cells in specified range are not blank (contain numbers, dates, or text). |
| date function | A function that inserts or calculates dates and times. |
| error value | A message in a cell that indicates some part of a formula is preventing Excel from returning a calculated value. |
| fill handle | A small black square in the lower-right corner of a selected cell or range that you drag over an adjacent cell or range to copy the original content and formatting into the selected range. |
| Goal Seek | A feature that automates the trial-and-error method by allowing you to specify a value for the calculated item, which Excel uses to determine the input value needed to reach that goal. |
| IF function | A logical function that tests a condition and then returns one value if the condition is true and another value if the condition is false. |
| logical function | A function that works with statements that are either true or false. |
| lookup function | A function that finds a value in a table of data and inserts it in another location in the worksheet, such as a cell or in a formula. |
| lookup table | A table that stores the data you want to retrieve with a lookup function in categories. |
| lookup value | The category you want to find in a lookup table. |
| MAX function | A function that displays the maximum value in a range. |
| Median function | A function that determines the middle value in a range. |
| median | The middle value in data. |
| MIN function | A function that displays the minimum value in the range. |
| mixed reference | A cell reference that contains both relative and absolute references; for example, the mixed reference for cell D2 can have an absolute row (such as $D6) or an absolute column (such as D$6). |
| nest | To place one thing inside another, such as a function inside another function. |
| relative reference | A cell reference that is interpreted in relation to the location of the cell containing the formula. |
| return values | The data values you want to retrieve from a lookup table. |
| TODAY function | A date function that displays the current date. |
| what-if analysis | A way to explore the impact that changing input values has on the calculated values in a workbook. |
| WORKDAY function | A function that displays the date of a weekday that is specified number of weekdays past a starting date. ( |
| VLOOKUP function | A function that returns values from a vertical lookup table. |
