Weekly Payroll Report Rate Hours Dep. Gross Pay Fed. Tax State Tax Net Pay % Taxes $24.90 40.00 3 $996.00 $176.12 $31.87 $788.00 20.883% 33.50 38.75 1,298.13 221.17 41.54 1,035.42 20.237% 12.90 66.00 8 851.40 108.74 27.24 715.41 15.972% 29.75 27.25 810.69 139.06 25.94 645.68 20.354% 21.35 45.00 5 960.75 153.69 30.74 776.32 19.197% 17.85 39.75 1 709.54 134.22 22.71 552.62 22.116% 256.75 $5,626.50 $933.00 $180.05 $4,513.45 19.782% $23.38 42.79 $937.75 $155.50 $30.01 $752.24 19.782% $33.50 66.00 8 $1,298.13 $221.17 $41.54 $1,035.42 20.237% $12.90 27.25 1 $709.54 $108.74 $22.71 $578.09 18.526% atthew lIII I IIIII II III wing formulas to determine the gross pay, federal tax, state tax, and net pay for all employees: 1.1 Gross Pay = Rate * Hours 1.2 Fed. Tax = 20% * (Gross Pay - Dep. * 38.46) 1.3 State Tax = 3.2% * Gross Pay 1.4 Net Pay = Gross Pay - (Fed. Tax + State Tax) 1.5 % Taxes = (Fed. Tax + State Tax) / Gross Pay als for hours, gross pay, federal tax, state tax, net pay, and % taxes paid ropriate functions to determine the average, highest, and lowest values of each column ing format: 4.1 Assign the Comma style format with two decimal places to the ranges B5:H9 and C4:C13. 4.2 Assign a Currency style format with a floating dollar sign to the ranges B11:B13 and E11:H13. 4 3 Assign the Num : style format with 0 decim D4.D13 and