| 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, such as $A$5. |
| Alphabetical order | Ascending order. |
| Amortization | A method for computing equal periodic payments for an installment loan. |
| Amortization table | Displays the interest and principal amounts for each payment of an installment loan. |
| 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. |
| Chronological | Ascending order. |
| 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. |
| Installment loan | Loan that is repaid in a series of periodic payments. |
| Key sort column | The column that contains the values that a sort is based on. |
| Linked cells | Data that is connected to the source cell and will automatically update if the source cell is changed. |
| MAX | Function that displays the largest value in a range of cells. |
| MIN | Function that displays the smallest value in a range of cells. |
| PMT | Function that calculates the periodic payment for an installment loan. |
| Principal | The amount of money owed on a loan. |
| 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. |
| Spreadsheet model | A worksheet containing data relating to a particular situation. |
| Static | Copied data that is not connected to the source data. |
| SUM | Function that adds the values in a range of cells. |
| Syntax | The expected form or structure of a function. |
| What-_if analysis | The process of making decisions using a spreadsheet model. |
| What-_if question | A question that is answered using a worksheet model. |
