Basic Microsoft Works Spreadsheets Tutorial

Adding Formulas in MS Works Spreadsheets

Basic MS Works Spreadsheet Tutorial

© Ted French

Calculating employee deductions

Note: For help on these steps, refer to the image above.

1. Click on cell C9.
   
   
2. Type the following: = B9 * C6
   
   
3. Press the F4 key on the keyboard to add dollar signs ( $ ) around C6 in the formula.
   
   
4. The formula in the formula bar should now read: = B9 * $C$6.
   
   
5. Press the ENTER key on the keyboard.
   
   
6. The dollar signs make C6 into an absolute cell reference which simplifies copying this formula to other cells.

Calculating net salary

1. Click on cell D9.
   
   
2. Type in the formula = B9 - C9 and press the Enter key on the keyboard.
   
   
3. Because the data used in the net salary formula is laid out differently than the data used in the deduction formula, we do not need to use absolute cell references in the net salary formula.

• Additional formula information:
  MS Works Spreadsheets Formulas

Return to Index page

• MS Works Spreadsheets Step by Step Tutorial
• Entering Data into MS Works Spreadsheets
• Widening Columns in MS Works Spreadsheets
• Adding the Date with the NOW Function
• Adding Formulas in MS Works Spreadsheets
• Copying Formulas in MS Works Spreadsheets
• Ms Works Spreadsheets Formatting - Changing Data Alignment
• Ms Works Spreadsheets Formatting - number formatting
• Ms Works Spreadsheets Formatting - Changing cell background color
• Ms Works Spreadsheets Formatting - Changing Font Color