Assignment #14

  (10 points)

  1. Watch the video Working with Formulas: Payroll (MS Excel).

  2. Create a Microsoft Excel OR Google Sheets document similar to the document developed in the video and shown below. Formulas must be created for OverTime, Gross Pay, Tax, Net Pay, Hour Comparison, Average, Minimum, and Maximum.



  3. Insert your name somewhere in the document.

  4. Save your work as "Assignment14".

  5. Upload your MS Excel file or embed the Google Sheets link on YOUR-CLASS-WEBSITE.   Help



Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
1. Document contains row headers, column headers, and data. Document uses borders and shading to enhance the visual impact. 3 0 2 3 __/3
2. Document uses formulas to compute: OverTime, Gross Pay, Tax, Net Pay, Hour Comparison, Average, Minimum, and Maximum. 7 0 4 7 __/7
Total points __/10