- name the sheet
- understand references
- enter information
- activate a cell
- enter row headings
- enter column headings
- make a column wider
- enter values
- calculate a difference
- calculate a percent diff
- sum some values
- calculate net income
- copy formulas
- copy and paste
- use the fill handle
- change a value
- extra bits
change a value
In reviewing this worksheet, I realize that we made an error when entering values. The actual sales amount for the month wasn't 8103 as we entered. It was really 9103! Better enter the correct value now.
Type 9103. This new value overwrites the value already entered.
Press Enter (Windows) or Return (Mac OS).
The value changes, but what's more important is that all of the formulas that referenced that value, either directly or indirectly, also change. Compare the orange highlighted cells in this illustration with the same cells in the illustration on the previous page to see for yourself.
This is the reason we use spreadsheet programs!