| A | B |
|---|
| SUM Function | A function that totals all of the cells in a range (most common). |
| Argument | The parameters of a function, inside of the (). |
| AutoSum | A formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function. |
| AVERAGE Function | A function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula. |
| COUNT Function | A function that determines how many cells in a range contain a number(disregards blanks and non-numbers). |
| COUNTA Function | A function that returns the number of cells in the selected range that contain text or values, but not blank cells. |
| 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. |
| SUBTOTAL Function | A function that returns a subtotal for a list. |
| FX Function | Found on the Forumlas Ribbon and to the left of the formula bar. |
| Function | A predefined formula that performs a calculation. |
| IF | Function returns one value if a condition is true and a different value when the condition is not true |
| COUNTIF | Function automatically counts cells that meet a specific condition |
| Array | What is used to build a single formulas that produce multiple results or that operate on a group of arguments? |
| COUNTIFS | Function automatically counts cells that meet multiple conditions? |
| Proper | Functions used to convert text from uppercase to title case |
| arguments | The parameters of a function. |
| conditional formula | A formula in which the result is determined by the presence or absence of a particular condition. |
| criteria | A condition you specify to limit which records are returned when filtering data. |
| lookup functions | An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook. |
| table | A range of cells in a worksheet that contains related data and can be used by a lookup function. |
| table array | Data in a table arranged in rows and columns. |
