Create a spreadsheet called Employee Data which contains the following:

1. Information for 10 to 15 employees; name the sheet Staff Information.

2. The worksheet should include the following columns: Employee ID, Last Name, First Name, Department, Address, City, State, Zip Code, and Phone Number. You can make up the data for each field. Remember, the Employee ID must be unique.

3. Add the following column headings: Hours, Pay Rate, Gross Pay, Withholding Taxes, and Net Pay.

4. Calculate Gross Pay, Taxes (the tax rate is 12%), and Net Pay. Pay special attention to your formulas.

5. Create a pie or column chart to show the employees net pay. Use the employees names and Net Pay in the chart. Place the chart on a chart sheet by itself, name it NetPay Chart.

6. Format the spreadsheet and chart to look professional; save the file. (Follow information on the rubric). Pay attention to detail and design, which will be considered in scoring.

7. Make sure that you include a Total row and a Total column on your spreadsheet

The information has to be made up. Fake names, made up employee id, etc.