| A | B |
|---|
| Begin a formula in the cell by typing an | equal sign = |
| Two ways to enter cell addresses into a formula: | Type cell addresses directly or point to cells |
| * | Multiplication |
| + | Addition |
| / | Division |
| - | Subtraction |
| Formulas can also be copied to | other cells |
| A formula is | a calculation using numbers (or other data) in a cell or from other cells. |
| A formula automatically calculates sum totals | horizontally (rows) and vertically (columns). |
| Excel calculates formulas in "natural order" of | exponents first, then multiplication and division, and then addition and subtraction operations. |
| This "natural order" can be altered | using parentheses around portions of the formula to be calculated before other items in the formula. |
| =SUM | Sums range of specified cells. |
| =AVERAGE | Averages specified cells (totals range and divides total by number of entries). |
| =MIN | Displays minimum value of specified cells. |
| =MAX | Displays maximum value of specified cells |
| =COUNT | Counts number of non-blank cells in specified range. |
| When calculating totals, you can use AutoSum on | the Home tab in the Editing group. |
| Use the down arrow next to the AutoSum tool | to display other common built-in functions, or use More Functions to choose a different function. |
| An absolute cell address refers to | an exact location on the worksheet. |
| Most formulas entered into an Excel worksheet are | relative. |
| If you copy a formula with a relative cell address, | it will automatically adjust for the new location. |
| To change to absolute cell address, | type dollar sign before row number or column letter. |
| (F4) | turns a cell address into an absolute address |
| Circular Reference | Cell where formula entered is included as part of formula. |
| DIV#/0! | Formula contains reference divided by 0. |
| #VALUE! | Formula contains incorrect data reference. |
| Operand | Something missing in your formula, as noted in error message. |
| When Excel detects and error or inconsistency in a formula. | it displays a suggestion on how to fix it. |
