+
Related Flashcards
Related Topics
Cards In This Set
| Front | Back |
|
A cell reference that does not change when copied because a dollar sign has been placed in front of the Column letter and Row number
|
Absolute Cell Reference
|
|
A method for computing equal periodic payments for an installment loan
|
Amortization Table
|
|
The data required by a function.
|
Arguments
|
|
A Function that adds the values in a range of cells and then divides the result by the number of cells in the range.
|
Average
|
|
In order from the highest to lowest
|
Descending
|
|
The upper-left cell of the range where data is to be pasted when copying or moving data between sheets.
|
Destination
|
|
Performs a calculation that results in a single value
|
Function
|
|
Function that is used to make a decision based on a comparison.
|
IF Function
|
|
Loan that is repaid in a series of periodic payments
|
Installment Loan
|
|
The column that contains the vaules that a sort is based on.
|
Key Sort Column
|
|
Data that is connected to the surce call and will automatically updated if the source cell is changed
|
Linked Cell
|
|
Function that displays the largest value in a range of cells.
|
Max Function
|
|
Function that displays the smallest value in a range of cells
|
Min Function
|
|
Function that calculates the periodic payment for an installment loan.
|
PMT Function
|
|
The amount of money owed on a loan
|
Principal
|
