Mr. Crocker's Class



26231853448053582670345440451485345440456628534544017087853003555709285377825The Legion of Superheroes has hired you as a summer intern in their software applications area. Wonder Woman has asked you to prepare a weekly payroll report for the six Superheroes listed in the table below. The pay for fighting crime isn’t great, but it’s very rewarding! EMPLOYEE NAME(Superhero working)RATE per HOUR(amount paid per hour)HOURS WORKED(total number per week)DEPENDENTS(number of super kids)Batman$40.0046.755Captain America$29.0040.54Iron Man$33.5018.52Spider-Man$22.75244Superman$37.50511Wonder Woman$25.00383PAYROLL TABLE Enter the worksheet title SUPERHEROES WEEKLY PAYROLL in cell A1Merge & Center A1 to H1Use italics for row 2 (Alt + Enter to type a new line underneath text)Change the height of row 2 to 30.00. (2) Use the following formulas to determine the GROSS PAY, FEDERAL TAX, STATE TAX and NET PAY for the first Super Hero (hey, Super Heroes have to pay taxes too!). BIG HINT: Pay attention to parenthesis and the “order of math operations”. To verify that your formula totals are correct, use a calculator (Start/Programs/Accessories/Calculator).GROSS PAY (cell E3): RATE multiplied by the HOURS WORKEDExample: =RATE*HOURS WORKEDFEDERAL TAX (cell F3): 20% multiplied by (GROSS PAY minus DEPENDANTS multiplied by 38.46)Example: =20%*(GROSS PAY-DEPENDANTS*38.46)Must change 20% into a decimalSTATE TAX (cell G3): 3.2% multiplied by the GROSS PAYExample: =3.2%*GROSS PAYMust change 3.2% into a decimalNET PAY (cell H3): GROSS PAY minus (FEDERAL TAX plus STATE TAX)Example: =GROSS PAY-(FEDERAL TAX+STATE TAX)Autofill (drag the corner) the formulas for the first Superhero to the remaining employeesChange row height of row 9 to 5.00 and fill with the color of your choosing.Calculate the totals for GROSS PAY, FEDERAL TAX, STATE TAX, and NET PAY in row 10.Use AUTOSUM…make sure selection is correct(4) Use formulas to determine the AVERAGE, MAX and MIN values of each column in rows 11, 12, and 13.Use AUTOSUM…make sure selection is correctFormat “Hours Worked” as a NUMBER with 2 decimal placesFormat “Dependents” as a NUMBER with 0 decimal places(5) Bold the worksheet title. Apply Currency Style “$” (except for Kids and Hours). Add a background color in cells A2 to H2. Apply all the formatting (borders, centering, right and left alignment, etc) exactly as you see in the worksheet above.(6) Change the widths of columns A through H for best fit, and MERGE & CENTER A9-H9.(7) Use the CONDITIONAL FORMATTING command to display bold font on a colored background for any Gross Pay greater than $1050.00 in the range E3:E8. Use the help feature or the Internet if you do not remember how to use conditional formatting.(8) Sort the employees in Descending order by Net Pay.(9) Insert a Pie Chart of your choice to reflect all the Superheroes and the Net Pay amounts only (select names hold control select net pay). Position the Chart below your data.Make sure your chart has a Title (above), labels (in a legend), and dollar amounts (inside end). See example for ideas.Format Chart background to the color of your choosing.Format Chart Title to a WordArt of your choice (format WordArt Styles)Bold Text in chartRound edges of chart (right click format chart area border styles rounded corners)(10) Insert image of your favorite superhero next to chart (OPTIONAL)(11) Save as Last-Payroll(12) Turn in to Google Classroom ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download