click below
click below
Normal Size Small Size show me how
Vocabulary
Lesson 5
| Term | Definition |
|---|---|
| Argument | The Parameters of a function |
| AutoSum | A formula that calculates (By default) the total from the adjacent cell through the first non numeric cell using the SUM function |
| AVERAGE Function | A function that calculates (By Default the total form the adjacent cell through the first nonnumeric cell using the SUM function in its formula |
| COUNT Function | A function the determines how many cells in a range contain a number |
| COUNTA Function | A function that returns the number of cells in the selected range that contain text or values, but not a blank cell |
| Function | A predefined formula that performs a calculation |
| MAX Function | A function that returns the largest value in a set of values |
| Merged Cells | Two or more cells combined into a single cell |
| MIN Function | A Function that determines the minimum value in a range of cells |
| NOW Function | A function that returns today's date and the current time, in the default format of MM/DD/YYYY |
| PMT Function | A function that requires a series of inputs regarding interest rate, loan amount (Principle), and loan duration, and then calculates the resulting loan payment |
| SUBTOTAL Function | A function that returns a subtotal for a list |
| SUM Function | A function that totals all of the cells in a range |
| TODAY Function | A Function that returns the current date in a worksheet |
| Trace Arrow | An arrow that shows the relationship between formulas and the cells they refer to in order to resolve a formula error |