G N21 Jx D E F G H 1 Your name Fica Rate 8.65% Sit rate 4% Fit 18% Payroll Register (take home pay) hours pay rate gross pay Fica Sit Fit Total deductions Net Pay Marie Osmond 21 $65 8 John Legend 38 $125 9 Pink 35 $90 10 Greg Allman 10 $50 11 Total 12 13 14 Directions: (check off each line as you do it so you don't forget any of the directions) 15 1. Calculate gross pay for each employee (hours times rate). Use cell references, not numbers so that I can change the fours and rate and still get correct answem 16 2 For row 7, enter your formulas and then copy them down to rows 8-10 17 Remember to use 5 signs in row 7, so the formulas can be copied down. Do not enter new formulas in rows 8-10 18 if your formulas are correct in row 7, you should be able to use the fill handle and copy the formulas down to row 8-10 19 f an individual works more than 40 hours in any week, they get paid overtime which is time and a half of the regular tage 20 Net pay is gross pay minus deductions 21. Fica (social security is 8.65% of gross pay), use cell references and copy it down 22 4. Sit (state income tax) is 4% of gross pay, use cell references and copy it down 23 5. Fit (federal income tax is 18% of gross pays, use cell references and copy it down 246. Go to D11 and use the fill handle and pull the formula across to column F through 25 7. For E11 though 111, have your formatting show double lines at the bottom and a single line at the top 26 8. in F7, Click on review tab, new comment and type "Fica rate is 8.65%", then click outside the cell 27 9. in G7, Click on new comment, sitrate is AX", then click outside the cell 28 10 In H7. Click on new comment..Titrate is 1896 then click outside the cell 29. 11. Clickon the Page Layout tab, click on Page Setup, click on sheet and change the comments to "print at end of sheet" 30 Excel will now print your comments at the end of the worksheet 31 if you print now, you will get the file and its comments printed 32 12 Autofit all columns but 33 13. Save file as payrollregisteryourname 34 14 Submit completed project in the dropbox where! ction ile was located 25