Create

Case Problem $2$

Data File needed for this Case Problem: NP$\_$EX$\_1-3.$xlsx

Meucci Digital, Inc. Travon Lee is a manager in the human resources department of Meucci Digital, a company that specializes in digital communications hardware and software. Travon wants to use a workbook to summarize employee data. The report will include the average employee's base salary, bonus salary, sick days, performance review, and the average number of years of employment at the company. You will add formulas and functions to the workbook to analyze the data. Because Travon may be adding data on other employees to the worksheet, all the calculations should be applied to entire columns of data rather than specified ranges within those columns. Complete the following:

Open the NP$\_$EX$\_1-3.$xlsx workbook located in the Excel$1>$ Case $2$ folder included with your Data Files. Save the workbook as NP$\_$EX$\_1\_$HRDepartment in the location specified by your instructor.

In the Documentation sheet, enter yout name in cell B$3$ and the current date in cell B$4.$

Add borders around the range $A3$:$B5.$

Go to the Shecl$2$ worksheet and rename it using Employees as the sheet name.

In cell $15$ of the Fmployees worksheel, calculate the number of days that Clay Aaron has worked for the company by subtracting the hire date in cell $H5$ from the report date in cell $C5.$ Copy the formula and then paste it to the range $16$:$1582.$

Insert a new column between columns $E$ and $F.$ In the new cell $F4,$ enter Full Name as the label. In cell F$5,$ enter Clay Aaron as the first name, and in cell F$6,$ enter Angel Abarca as the second name. Allow Flash Fill to enter the remaining full names of employeec in the column.

In cell A$1,$ enter Meucci Digital, Inc. as the title. In cell A$2,$ enter Employee Summary as the label. Increase the font size of cell $AI$ to $22$ points and increase the font size of cell $A2$ to $16$ points.

Fniter the labels shown in Fipure $1-45$ in the speriffed cells in prepiration for adding a summary of the employee data.

Labels for employee information

$\backslash$table$[[$Cell$,$Text$],[$A$4.,$Nomber of Fimployent$],[A6,$Average Diys of Employments$],[$A$],$Averapge Yaare of Enytogmo?$],[$A$9.,$Total Bave $5$a ary$],[$A$10$:$,$Average liase laqliny$],[$A$14.,$Thral Roguave$]]$