1. Computing

Basic Microsoft Works Spreadsheets Tutorial

By

5 of 10

Adding Formulas in MS Works Spreadsheets
Basic MS Works Spreadsheet Tutorial

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.

Return to Index page

©2014 About.com. All rights reserved.