Spreadsheets Project

A Simple Payroll table

For this project you will produce a simple payroll table that computes salaries for employees based on an hourly wage, regular hours and time-and-a-half for overtime. You'll also handle taxes and sort the results.

Start by downloading this raw payroll data and saving it on your H: drive. Then, modify the spreadsheet so that it looks something like this sample solution sheet, but with appropriate formatting. NOTE: The data in the example is different from the data you are using. Remember to use formulas/functions as appropriate.

Some things to note:

In your final solution, check that you meet these criteria:


Submit your completed spreadsheet in Moodle.