write 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, theEmployee 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). Payattention 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.8. Export the Spreadsheet or Chart to appropriate places in the Word report.9. Format the spreadsheet with a header or footer, vertical and horizontal centering, and print in landscapeorientation.10. Submit the Employee Data spreadsheet to the Drop box