Term
|
Definition
| A function that totals the number of ITEMS in a range of cells |
|
|
Term
|
Definition
| A function that adds a range of cells |
|
|
Term
|
Definition
| A function that figures the average of a range of cells |
|
|
Term
|
Definition
| Cell reference that changes when it is copied or moved |
|
|
Term
|
Definition
| Cell reference that does not change when it is copied or moved |
|
|
Term
|
Definition
| Function that figures equal payments on an installment loan |
|
|
Term
|
Definition
| A function that lists how many cells in a range contain a value |
|
|
Term
|
Definition
| Function that finds the highest value in a range of cells |
|
|
Term
|
Definition
| Function that finds the lowest value in a range of cells |
|
|
Term
|
Definition
| the value the function uses to perform a calculation |
|
|
Term
|
Definition
| A function that finds the square root of a number |
|
|
Term
|
Definition
| A function that designates a specific number of decimal places the answer will be expressed in. |
|
|
Term
|
Definition
| A function that finds the estimated standard deviation of the numbers in the range |
|
|
Term
|
Definition
| Functions that brings about a "TRUE" result if BOTH logical tests are true |
|
|
Term
|
Definition
| A function that contains 2 values or outcomes based on whether the condition is true or false |
|
|
Term
|
Definition
| These functions analyze loans and investments |
|
|
Term
|
Definition
| Functions that describe quantities of data |
|
|
Term
|
Definition
| Dialog box which provides a description of each argument you need to enter for the selected function |
|
|
Term
|
Definition
| Functions which display text or values if certain conditions exist |
|
|
Term
|
Definition
| Function that returns a "TRUE" value if any of the arguments are true |
|
|
