Term
| 1.Absolute Cell Reference |
|
Definition
| A cell reference that does not change when copied |
|
|
Term
|
Definition
|
|
Term
|
Definition
| A method for computing equal periodic payments for an |
|
|
Term
|
Definition
| Displays the interest and principal amounts for each payment |
|
|
Term
|
Definition
| The data required by a function. |
|
|
Term
|
Definition
| In order from lowest to highest. |
|
|
Term
|
Definition
| Function that adds the values ina range of cells and then |
|
|
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 |
|
|
Term
|
Definition
| Performs a calculation that results in a single value. |
|
|
Term
|
Definition
| Function that is used to make a decision based on. |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
Term
|
Definition
| Arranging data in a specified order. |
|
|
Term
|
Definition
| The cell or range of data to be copied when copying or moving |
|
|
Term
|
Definition
| A worksheet containing data relating to a particular situation. |
|
|
Term
|
Definition
| Copied data that is not connected to the source. |
|
|
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 decision using a spreadsheet. |
|
|
Term
|
Definition
| A question that is answered using a worksheet model |
|
|
