**Don't waste paper! ** A one page printable copy of the information is available.

Click on review link by the mini-exam for this unit.

- If the information is elsewhere in the spreadsheet
- NEVER re-type the information.
- Just refer to cells

- Utmost, most important concept in spreadsheets:

**Refer to Cells** - Also consider storing in a cell, numbers that will be needed in more than one formula
- Then refer to that cell when building the formula

- Most important concept -
**Refer to Cells**

A | B | |
---|---|---|

1 | Sales | $10,567.00 |

2 | Expenses | $8,452.00 |

3 | Income | =B1-B2 |

The formula entered in Cell B3 refers to cells B1 & B2. When **Enter** is pressed the formula is still there, but the answer appears in the cell. The formula can still be seen in the formula bar at the top of the spreadsheet. Double click on a cell to see and edit the formula.