Term
|
Definition
| Finds the periodic payments for a loan based on constant interest rate. |
|
|
Term
|
Definition
| Calculates the future value of a series of equal payments or an annuity |
|
|
Term
|
Definition
| Returns the seriel number of the current date and time |
|
|
Term
|
Definition
| Resturns the seriel number that represents a particular date |
|
|
Term
|
Definition
| you can perforn conditional tests on values and formulas |
|
|
Term
|
Definition
| performs a particular action if the answer is true and another action is the answer if false |
|
|
Term
|
Definition
| the condition or logical test IF(quota=>1000000). |
|
|
Term
|
Definition
| click the enter button ont he formula bar and excel will recalculate the result of the formula |
|
|
Term
|
Definition
| two possible actions - the actual sales times 15% or a zero |
|
|
Term
|
Definition
| refer to cells relative to a position in a formula |
|
|
Term
|
Definition
| refer to cells in a speficific location |
|
|
Term
|
Definition
| either the column remains absolute and the row is relative or the column ius relative and the row is absolute |
|
|
