| A | B |
| = (equal sign) | this must be keyed first to indicate a formula is being typed |
| constant | the part of the formula entered directly as a value |
| average | adds a range of cells together and divides them by the number of entries |
| max | finds the maximum value in a range |
| min | finds the minimum value in a selected area |
| CTRL +` | displays formulas in a worksheet |
| sum | adds all of the numbers in a range |
| function | prewritten formula |
| formula bar | you find the Insert Function button here |
| point mode | enables you to use the mouse to select cells for use in a formula |
| #REF! | message displayed to indicate a cell reference error |
| calculation | command that enables a user to specify when a formula is computed |