Updating MS Works Spreadsheets Formulas
When you use cell references in an MS Works spreadsheet formula, the formula will automatically update whenever the relevant data in the spreadsheet changes.
For example, if you realize that the data in cell A1 should have been an 8 instead of a 3, you only need to change the contents of cell A1.
MS Works updates the answer in cell C1. The formula, itself, doesn't need to change because it was written using cell references.
Changing the data
- Click on the cell A1
- Type an 8
- Press the ENTER key on the keyboard
The answer in cell C1 where the formula is, immediately changes from 5 to 10, but the formula itself is unchanged.