Term
|
Definition
| 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. |
|
|
Term
|
Definition
| A method for computing equal periodic payments for an installment loan. |
|
|
Term
|
Definition
| displays the interest and principal amounts for each payment of an installment loan. |
|
|
Term
|
Definition
| The data required by a function |
|
|
Term
|
Definition
| 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. |
|
|
Term
|
Definition
| Function that adds the values in a range of cells and then divides the result by the number of cells in the range. |
|
|
Term
|
Definition
| In order from highest to lowest. |
|
|
Term
|
Definition
| The upper-left cell of the range where data is to be pasted when copying or moving data between sheets. |
|
|
Term
|
Definition
| Performs a calculation that results in a single value. |
|
|
Term
|
Definition
| - Function that is used to make a decision based on a comparison |
|
|
Term
|
Definition
| Loan that is repaid in a series of periodic payments |
|
|
Term
|
Definition
| The column that contains the values that a sort is based on. |
|
|
Term
|
Definition
| - Data that is connected to the source cell and will automatically update if the source cell is changed. |
|
|
Term
|
Definition
| Function that displays the largest value in a range of cells. |
|
|
Term
|
Definition
| Function that displays the smallest value in a range of cells. |
|
|
Term
|
Definition
| Function that calculates the periodic payment for an installment loan. |
|
|
Term
|
Definition
| The amount of money owed on a loan. |
|
|
Term
|
Definition
| Used to compare two values. |
|
|
Term
|
Definition
| Changes a value by rounding it to a specific number of decimal places. |
|
|
Term
|
Definition
| - Arranging data in a specified order. |
|
|
Term
|
Definition
| The cell or range of data to be copied when copying or moving data between sheets. |
|
|
Term
|
Definition
| A worksheet containing data relating to a particular situation |
|
|
Term
|
Definition
| Copied data that is not connected to the source data. |
|
|
Term
|
Definition
| Function that adds the values in a range of cells |
|
|
Term
|
Definition
| The expected form or structure of a function. |
|
|
Term
|
Definition
| The process of making decisions using a spreadsheet model |
|
|
Term
|
Definition
| A question that is answered using a worksheet model. |
|
|
