Basic Excel 2007 Spreadsheet Tutorial

Adding Formulas in Excel 2007

The Fill Handle in Excel 2007

© Ted French

Writing the employee deductions formula

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.

Writing the net salary formula

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

• Additional formula information:
  Excel 2007 Formulas Step by Step Tutorial

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.
   
   
4. Click on cell D9.
   
   
5. Repeat steps 2 and 3 and drag the fill handle down to cell D12.

Return to Index page

• Excel 2007 Step by Step Tutorial
• Entering Data into Excel 2007
• Widening Columns in Excel 2007
• Adding the Date and a Range Name
• Adding Formulas in Excel 2007
• Excel 2007 Formatting - Applying Styles
• Excel 2007 Formatting - Changing Data Alignment
• Excel 2007 Formatting - Number Formatting
• Excel 2007 Formatting - Changing Font Color