| A | B |
|---|
| assumptions | A cell value that you can change to determine a new value for formulas. |
| office clipboard | A temporary storage area in the computer's memory that lets you collect text and objects from a file created by a Microsoft Office app, and then paste the text or objects into files created by any Microsoft Office app |
| drag and drop | The technique of moving an item by selecting it and then dragging the selection to a new location; can be used to move an Excel cell or range |
| #REF! | An Excel message indicating a cell reference error. |
| format symbols | In Excel, a symbol that assigns a format to numbers as they are entered. |
| NOW function | In Excel, a function that returns a number that corresponds to the system date and time, beginning with December 31, 1899. |
| volatile function | A function that automatically recalculates it values every time Excel does any calculation in the workbook. |
| absolute cell reference | In a formula, a cell address that refers to a specific cell and does not change when you copy the formula. |
| relative cell reference | In a formula, a cell address that automatically changes to reflect the new location when the formula is copied or moved; the default type of referencing used in Excel worksheets; also called a relative reference. |
| mixed cell reference | A cell reference that changes when the formula containing that reference is moved to a new location. |
| logical test | The first part of an IF function; if the logical test is true, then the second part of the function is applied; if it is false, then the third part of the function is applied. |
| IF function | In Excel, a function that assigns a value to a cell based on a logical test. |
| nested IF function | A function in which the action to be taken for the true or false case indicates another IF function. |
| category names | A range that identifies the major group for a chart. |
| data series | Data from a column or row in a sheet; the set of values represented in a chart. |
| what-if analysis | A way to explore the impact that changing input values has on calculated values and output values. |
| goal seek | A feature that reverses the trial-and-error process by allowing you to specify an output value and then working backward to find the input value needed to reach that goal. |
| accessibility | The practice of removing barriers that might prevent individuals with disabilities from interacting with data or an app. |
