Illiana Custom Homes Weekly Payroll Report Dep. Gross Pay Fed. Tax State Tax 1 2 B Employee Jedi, Hubert 5 Kaden, Hadef Rate Hours $ 24.90 40.00 3 33.50 38.75 5 5 Pancer, Dion 12.90 66.00 8 7 Rifken, Felix 29.75 27.25 3 B Sanchez, Maria 21.35 45.00 5 BScarff, Heidi 17.85 39.75 1 0 Totals Net Pay % Taxes 1234567890-23 1 Average 2 Highest 3 Lowest 8 FormatPoints=10 9 Name: AyadMaged |||||||||||| O Instructions 4 1. Use the following 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 1.3 State Tax Instructions = = + 20% (Gross Pay Dep. *38.46) 3.2% * Gross Pay CRI Clothing Illiana Custom Homes structions 1. Use the following 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 1.3 State Tax 1.4 Net Pay 1.5 % Taxes * 20% (Gross Pay - Dep. * 38.46) 3.2% * Gross Pay Gross Pay (Fed. Tax + State Tax) (Fed. Tax + State Tax) / Gross Pay 2. Calculate totals for hours, gross pay, federal tax, state tax, net pay, and % taxes paid 3. Use the appropriate functions to determine the average, highest, and lowest values of each column 4. Do the following 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 Number style format with O decimal to the range D4:D13 and center the range. 4.4 Assign a Percent style format with three decimal places to the range 14:113. 5. Use the Conditional Formatting command on the Format menu to display white, bold font on a blue background for any rate in the range B4:B9 greater than $25.00