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 |