| A | B |
|---|
| Absolute Cell Reference | A cell reference that does not change when copied because a dollar sign has been placed in front of both the column letter and row number |
| Arguments | The data required by a function. |
| Ascending order | In order from lowest to highest. Also called alphabetical order when the data is text and chronological order when the data is times or dates. |
| AVERAGE | Function that adds the values in a range of cells and then divides the result by the number of cells in the range. |
| Descending | In order from highest to lowest. |
| Destination | The upper-left cell of the range where data is to be pasted when copying or moving data between sheets. |
| Function | Performs a calculation that results in a single value. |
| IF function | Function that is used to make a decision based on a comparison. |
| MAX | Function that displays the largest value in a range of cells. |
| MIN | Function that displays the smallest value in a range of cells. |
| Relational operators | Used to compare two values. Operators include = |
| ROUND function | Changes a value by rounding it to a specific number of decimal places. |
| Sorting | Arranging data in a specified order. |
| Source | The cell or range of data to be copied when copying or moving data between sheets. |
| SUM | Function that adds the values in a range of cells. |
| What-if analysis | The process of making decisions using a spreadsheet model. |
| What-if question | A question that is answered using a worksheet model. |
