M FIE 90 C D F G H 1 Your name Fica Rate 8.65% 2 Sitrate 4% Fit 18% 4 Payroll Register 5 6 (take home payl hours pay rate cross pay Fica Sit 7 Marie Osmond Total deductions Net Pay 21 65 8 John Legend 38 125 9 Pink 35 10 Greg Allman 10 SO 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 tours and rate and still get correct answers 16 2. Forrow 7, enter your formulas and then copy them down to rows 8-10 17 Remember to use S 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 of an individual works more than 40 hours in any week, they get paid overtime which is time and a half of the regular rate 20 Net pay is gross pay minus deductions 21 3. 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 S. Fit (federal income tax is 18% of gross payl, 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 2. For E11 though 11, have your formatting show double lines at the bottom and a single line at the top 26 B, in F7, Click on review tab, new comment and type "Fica rate is 1.65%, then click outside the cell 27 9. in G. Click on new comment, 'sitrate is 4% then click outside the cell 28 10. in H7, click on new comment trate is 1, then click outside the call 29 11. Click on the Page Layout tab, click on Pare 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 A 33 13. Save file as payroliregisteryourname 34 14. Submit completed project in the dropbox where the instruction file was located 35 36 Must us cell references whenever possible, not actual 37 This is what is referred to as what if, where we can then change a number 38 and all cells will recalculate automatically correctly 39 40 Use your wars when you don't want the row or column to change 41 it won't change your answer to that we can start to really understand this concept and will be able to use it when needed 28 0 Conc Form 552 M D 15 1. Calculate gross pay for each employee [hours times rate). Use cell references, not numbers so that I can change the hours and rate and still get correct answers 16 2. For row 7, enter your formulas and then copy them down to rows 8-10 17 Remember to use $ 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 an individual works more than 40 hours in any week, they get paid overtime which is time and a half of the regular rate. 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 pay), use cell references and copy it down 24 6. Go to D11 and use the fill handle and pull the formula across to column F through 25 7. For E11 though J11, 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, "sit rate is 4%, then click outside the cell 28 10. in H7, Click on new comment, fitrate is 18%, then click outside the cell 11. Click on 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 A 33 13. Save file as payroliregisteryourname 34 14. Submit completed project in the dropbox where the instruction file was located 35 36 Must use cell references whenever possible, not actuall's 37 This is what is referred to as what it where we can then change a number 38 and all cells will recalculate automatically correctly. 39 40 Use your $igns when you don't want the row or column to change 41 even if it won't change your answer so that we can start to really understand this concept and will be able to use it when needed 42 43 Note: 44 When in a cell with a comment, and you click on the review tab 45 If you click on show/hide comment it is a toggle and the comment will either appear on the screen or disappear 46 if you click on the cell with the red triangle and click on delete on the ribbon (not the delete key that will do call contents), the comment will be eliminated 47 48 This project will be graded using the instructions 49 Each instruction is worth points, for example, if you don't 50 copy down a formula, but instead enter it, you won't 51 get credit) 52 53 These instructions are trying to reinforce skills from 54 previous week 55 Sheet B G 552 A D E F H J 3 1. Calculate gross pay for each employee (hours times rate). Use cell references, not numbers so that I can change the hours and rate and 6 2. For row 7, enter your formulas and then copy them down to rows 8-10 7 Remember to use $ signs in row 7, so the formulas can be copied down... Do not enter new formulas in rows 8-10 8 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 9 If an individual works more than 40 hours in any week, they get paid overtime which is time and a half of the regular rate. 0 Net pay is gross pay minus deductions 1 3. Fica (social security is 8.65% of gross pay), use cell references and copy it down 2 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 pay), use cell references and copy it down 24 6. 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, "sit rate is 4%", then click outside the cell 28 10. In H7, Click on new comment, "fit rate is 18%", then click outside the cell 29 11. Click on 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 A 33 13. Save fileas payrollregisteryourname 34 14. Submit completed project in the dropbox where the instruction file was located 35 36 Must use cell references whenever possible, not actual's 37 This is what is referred to as what it, where we can then change a number 38 and all cells will recalculate automatically correctly. 39 40 Use your signs when you don't want the row or column to change 41 even if it won't change your answer so that we can start to really understand this concept and will be able to use it when needed 42 43 Note: 44 When in a cell with a comment, and you click on the review tab 4s you click on show/hide comment it is a toggle and the comment will either appear on the screen or disappear 46 you click on the cell with the red triangle and click on delete on the ribbon (not the delete key that will do cell contents), the comment will be eliminated 47 48 This project will be graded using the instructions. 49 Each instruction is worth points (so, for example, if you don't 50 copy down a formula, but instead enter it, you won't 51 get credit) 52 B D E F G H Fica Rate Sit rate Fit 8.65% 4% 18% hours Fica Sit 1 Your name 2 3 4 Payroll Register 5 6 7 Marie Osmond 8 John Legend 9 Pink 10 Greg Allman 11 Total 12 13 (take home pay) Total deductions Net Pay Fit pay rate gross pay 21 65 38 125 35 90 10 50