| A | B |
|---|
| SUM | Function that adds all of the numbers in a range of cells |
| Relative Reference | Automatically adjusts cell references when copying values in Excel to a new location |
| Auto Sum | Displays the total of the selected cells directly after the selected cells (on the Home Tab) |
| Function | Prewritten (shortcut) formula built into Microsoft Excel |
| AVERAGE | Excel Function that averages numbers in a range; may be used to estimate future information |
| MIN | Excel Function for Minimum |
| MAX | Excel Function for Maximum; finds the highest number in the range |
| COUNTIF | Excel Function that counts cells meeting specified criteria |
| Absolute | Cell reference that keeps a location or range of cells constant as its formula is copied to a new destination |
| TODAY | Function that inserts today's date in a worksheet so that it automatically updates each time the worksheet opens |
| Worksheet Reference | Using the sheet name rather than the cell address to reference cells in other sheets in a workbook formula |
| Function Library | Command Group on the Formula Ribbon used to choose from various categories of functions used in a worksheet |
| Defined Names | Group on the Formulas Ribbon containing a command to create names for cells in a formula |
| Calculation | Group on the Formula Ribbon enabling a user to specify when a formula is computed |
| =D6*F9 | Formula that multiplies values |
| =D6-F9 | Formula that subtracts values |
| NOW | Function that inserts the current date and time |
| =SUM(C3:G8) | Function (Shortcut formula) that adds the values in the range of cells from C3 to G8 |
| =MAX(C3:G8) | Finds the largest number in the range of cells from C3 to G8 |
| =$F$3-8 | Formula that will not change as it is copied to other cells |
| =A1+B1+C1+D1 | Example of a formula |
| Condition | Made of two values and a relational operator, and is true or fales for each cell in the range |
