| Amortization | The process of distributing periodic payments over the life of a loan.
|
 |
|
|
| Amortization schedule | Lists the monthly payment, the amount of the payment applied towards reducing the principal (loan amount), and the amount of the payment that pays the interest due each month.
|
|
|
|
| Argument list | The collection of cells, cell ranges, and values listed in the comma-separated list between a function's parentheses.
|
|
|
|
| Arguments | A list of zero or more items enclosed in parentheses and following the function name.
|
|
|
|
| Conditional test | An equation that compares two values, functions, formulas, labels, or logical values.
|
|
|
|
| Date constant | A date such as 12/12/2003.
|
|
|
|
| Lookup function | Uses a search value to search a table-a range of cells-for a match or close match and then returns a value from the table as a result.
|
|
|
|
| Lookup table | The table that a lookup function searches.
|
|
|
|
| Lookup value | The value being used to search a lookup table.
|
|
|
|
| Model row | Contains distinct formulas that you can copy to other rows and not have to modify any copied cell formulas afterwards.
|
|
|
|
| Positional arguments | Arguments whose position in the argument list is important and inflexible.
|
|
|
|
| Principal | Amount of money borrowed.
|
|
|
|
| Protect (worksheet) | Excel disallows modifications to cells or new values in cells.
|
|
|
|
| Prototype | A proposed worksheet model.
|
|
|
|
| Range errors | Values that are either too large or too small (negative or too close to zero, for example) that do not make sense in the context of the application.
|
|
|
|
| Range name | A name that you assign to a cell or cell range that can replace a cell address or cell range in expressions or functions.
|
|
|
|
| Rate | Percentage interest rate.
|
|
|
|
| Relational operator | Compares two values and the result in either true or false.
|
|
|
|
| Term | Time period over which you make periodic payments.
|
|
|
|
| Time value of money | $100 today is more valuable than $100 is next year.
|
|
|
|
| Unlocked | An attribute of a cell that leaves it unprotected.
|