1 Aall &4 — IVa) DLA L/hCreate a spreadsheet (file) and save it as Employee Data whichcontains the following:1) Name sheet] as Staff Information.2) Type the name of the company in cell Al.3)...

I will send you a research paper base on the numbers on the research paper you will create an excel employment spread sheet


1 Aall &4 — IVa) DLA L/h Create a spreadsheet (file) and save it as Employee Data which contains the following: 1) Name sheet] as Staff Information. 2) Type the name of the company in cell Al. 3) Create these columns using the headings: (start in cell A2) a) Employee ID b) Employee Name (Last name and first name) ¢) Position d) Department e) Street fn City o) State n) Zip Code iy Phone Number j) Weekly Hours x) Hourly Pay Rate 1) Weekly Gross Pay m) Withholding Taxes n) Weekly Net Pay 4) Enter information for 10 (ten) employees. You can make up the data for each field. Remember, the Employee ID must be unique. 5) Go to cell P1, then type Tax Rate. Go to cell Q1 and type 12%. 6) Calculate the following: a) Gross Pay (multiply hours worked by pay rate) b) Withholding Taxes (the tax rate is located in cell Q1) (multiply gross pay by the tax rate; change to absolute as necessary) Pay special attention to your formulas. ¢) Weekly Net Pay for each employee. (Net Pay is your take home pay) 7)In cell A13, enter the word Total. Calculate the total for the following columns: Weekly Gross Pay, Withholding Taxes and Weekly Net Pay. 8) Format the following data: a) Center the company name from cell Al through cell N1, bold it, and change to font size 14. b) Bold all column headings/titles and change to red font. ¢) Format the following columns as currency. + Weekly Hours + Hourly Pay Rate « Weekly Gross Pay + Withholding Taxes + Weekly Net Pay 4) Pay Rate, Gross Pay, Withholding Taxes, Net Pay) with § signs e) Format cells with “all borders”. 9) Copy this sheet to a new sheet, display/show the formulas, and rename the sheet as “Formula Sheet”. Adjust column width, as necessary. 10) Create a column chart to show the employees’ net pay. Use the employees’ names and weekly net pay in the chart located in the Staff Information sheet. Move the chart on a new sheet and name it NetPay Chart. Change the chart title to Weekly Net Pay. 11) Format the spreadsheet: a) with a footer (type your name in the center and date on the right side) —