Copy all formulas down the column. Use statistical functions to find the average, lowest and highest scores on test 1. Copy formulas across the four test columns. Access Sheet 1. Write a formula for the Gross pay that will work for every employee, adding in a bonus and overtime even if there is none.
Overtime is figured at time and a half.
Total gross pay will be 3125. Using absolute references to the cells containing the tax rates, calculate federal and state taxes. Total federal taxes are 781.25. State taxes are 375. Figure net pay.