1. Home
  2. Computing & Technology
  3. Spreadsheets

Basic Open Office Calc Spreadsheet Tutorial

By , About.com Guide

5 of 9

Adding Formulas

Basic Open Office Calc Spreadsheet Tutorial

Basic Open Office Calc 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 in the formula = B9 * rate and press the Enter key on the keyboard.

Calculating net salary

  1. Click on cell D9.

  2. Type in the formula = B9 - C9 and press the Enter key on the keyboard.

Copying the formulas in cells C9 and D9 to other cells:

  1. Click on cell C9 again.

  2. Move the mouse pointer over the fill handle (a small black dot) in the bottom right corner of the active cell.

  3. When the pointer changes to a black "plus sign", click and hold down the left mouse button and drag the fill handle down to cell C12. The formula in C9 will be copied to cells C10 - C12.

  4. Click on cell D9.

  5. Repeat steps 2 and 3 and drag the fill handle down to cell D12. The formula in D9 will be copied to cells D10 - D12.

Return to Index page

Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Other Spreadsheets
  5. Open Office Calc
  6. Open Office Calc Tutorial - Open Office Calc Step by Step Tutorial

©2009 About.com, a part of The New York Times Company.

All rights reserved.