The Federal Withholding Rate is located in B13 by rMQDu4g

VIEWS: 0 PAGES: 6

									                                             Payroll

1. Position mouse between Columns A and B and double click.




2. Select cell C4 and text wrap the title Regular Hours (Regular CTRL ENTER Hours). Select D4
   and text wrap Overtime Hours. Select E4 and text wrap Gross Pay. Select F4 and text wrap
   Federal Withholding. Select G4 and text wrap State Withholding. Select H4 and text wrap
   Total Deductions. Select I4 and text wrap Net Pay. Adjust the column width as necessary.




3. Select E5 and enter the formula to calculate Gross Pay. The Overtime Rate is located in B12.
   Because the rate must remain constant when you use the fill handle to copy the formula, you
   will make it absolute. Select E5 and use the fill handle to copy the formula

   Gross Pay = (Regular Hours * Pay Rate) + (Regular Hours * Overtime Rate * Overtime Hours)

   =(C5*B5) + (C5*$B$12*D5)
4. Select F5 and create the formula for Federal Withholding. The Federal Withholding Rate is
   located in B13. Because the rate must remain constant when you use the fill handle to copy the
   formula, you will make it absolute. Select F5 and use the fill handle to copy the formula

   =Gross Pay * Federal Withholding

   =E5 * $B$13
5. Select G5 and create the formula for State Withholding. The State Withholding Rate is located
   in B14. Because the rate must remain constant when you use the fill handle to copy the
   formula, you will make it absolute. Select G5 and use the fill handle to copy the formula

   =Gross Pay * State Withholding

   =E5 * $B$14




6. Select H5. You can create the Total Deductions formula one of two ways. You can use the
   AutoSum icon and select F5:G5 or you can add the two cells =F5 + G5. Select H5 and use the
   fill handle to copy the formula.
7. Select I5 and calculate Net Pay. The formula to calculate Net Pay is: Gross Pay – Total
   Deductions. =E5 – H5. Select I5 and use the fill handle to copy the formula.




8. Select E9:I9 and click the AutoSum icon to calculate the totals.
9. Select B5:B8. Press and hold the CTRL key and select E5:I9. Right Mouse Click the
   selection and choose Format Cells. Select Currency, two decimal places, $, and format for
   negative numbers.
10. Select A1:I1 and Merge/Center. Select A2:I2 and Merge/Center. Select A11:B11 and
    Merge/Center. Select A17:B17 and Merge/Center.

11. Bold rows 1, 2, 4, 11, and 17.

12. Select E9:I9, click the Borders drop-down arrow, and select Top and Double Bottom Border.




13. Answer the questions in B18:B20 using the functions located in the AutoSum drop-down arrow.

								
To top