| A | B |
|---|
| Assumptions | Values in cells that you can change to determine new values for formulas. |
| Office Clipboard | A temporary storage area in the computer’s memory that allows you to collect text and graphics from any Office document and then paste them into almost any other type of document. |
| drag and drop | Using a mouse to move or copy cells. |
| #REF! | Excel message used to indicate a cell reference error. |
| format symbols | Symbol that assigns a format to numbers as they are entered. |
| NOW function | Excel function that returns a number that corresponds to the system date and time beginning with December 31, 1899. |
| volatile function | Function in which the number that the function returns is not constant but changes each time the worksheet is opened. |
| absolute cell referencing | A cell reference that remains constant when copying a formula or function (that is, the cell references do not change relative to where you are copying the formula). |
| relative cell reference | A cell reference that Excel adjusts as it is copied to the destination area. |
| mixed cell reference | A cell reference where one factor remains constant and the other one varies. |
| IF function | Function that assigns a value to a cell based on a logical test. |
| nested IF function | Function in which the action to be taken for the true or false case includes yet another IF function. |
| category names | Ranges that identify the major groups for a chart. |
| what-if analysis | Scrutinizing the impact of changing values in cells that are referenced by formulas in other cells. |
| accessibility | The practice of removing barriers that may prevent individuals with disabilities from interacting with data or an app. |
