7 Calculate FICA in cell J5 based on gross pay and the
6.000
FICA rate( stored in cell B23). Use relative and absolute cell references appropriately.
8 Calculate the net pay in cell K5 by subtracting the taxes 6.000 from the gross pay for the first employee.
9 Copy the formulas in the range E5: K5 to the range 6.000
E6: K16.
10 Calculate the total regular pay, overtime pay, gross pay,
8.000 taxable pay, withholding tax, FICA, and net pay in the respective cells within the range E17: K17.
11 Apply Accounting Number Format to the ranges 6.000
C5: C16, E5: K5, and E17: K17.