Basic Formatting in Excel - Tutorial Part 2

How to Create a Formula in Excel

creating a formula in Excel

© Ted French

Writing and Copying the Deductions Formula

1. Select cell C7 in the spreadsheet.
2. Type = B7 * rate in cell C7 to multiply the deductions rate times the gross salary.
3. Press the ENTER key on the keyboard.
4. Select cell C7 again
5. Click on the fill handle in the bottom right corner of cell C7.
6. Drag down with the mouse to cell C10 to copy the formula from C7 to cells C8 to C10.

Index: Basic Formatting in Excel - Tutorial Part 2

1. Formatting Tutorial - Overview
2. How to Right Align Text in Excel
3. How to Center Align Text in Excel
4. How to Create a Range Name in Excel
5. How to Create a Formula in Excel
6. How to Create a Formula in Excel (con't)
7. How to Use the Date Function in Excel