Term
|
Definition
| a cell reference that does not change when copied because a dollar sign has been placed in front of both of the column letter and row number such as $a$5 |
|
|
Term
|
Definition
|
|
Term
|
Definition
| A method for computing equal periodic payments for an installment loan |
|
|
Term
|
Definition
| Displays the interest and principle 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 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
|
|
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 an comparison. |
|
|
Term
|
Definition
| Loan that is repaid in a series of periodic payments. |
|
|
Term
|
Definition
| the column that contains the values that 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 or cells. |
|
|
Term
|
Definition
| Function that calculates the periodic payment for 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 a 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
| Function that adds the values in a range of cells. |
|
|
Term
|
Definition
| Copied data that is not connected to the source data. |
|
|
Term
|
Definition
| the excepted 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 |
|
|
