Excel 3 – Payroll
For this exercise we will work with developing basic calculations for total hours worked, regular pay and overtime pay. This includes working with formatting numbers and formulas, and editing an existing spreadsheet. After reviewing the tutorials follow the instructions on creating a Payroll spreadsheet.
Instructions
Download these files: Excel 3 Outline - Payroll, Payroll Student.xlsx
Review: Beginning Spreadsheet Tutorial - Add formulas and references; Basic Math in Excel; Add number in Excel
After completion upload the file to this assignment by clicking on the title, select Add Submission, drag and drop your file into the box or select your file to upload and press save changes.
This assignment has a point value of 20 points.