please solve this project, subject:Computer Applications GETTING STARTED Save the file NP$\_$EX$365\_2021\_$CS$1-4$a FirstLastName$\_1.$xisx as NP$\_$EX$365\_2021\_$CS$1-4$a$\_$FirstLastName$\_2.$xlsx Edit the file name by changing $"1"$ to $"2".$ If you do not see the x lsx file extension, do not type it$.$ The file extension will be added for you automatically. $-$ With the file NP$\_$EX$3652021\_$CS$1-4$a FirstlastName$\_2.$selsx open, ensure that your first and last name is displayed in cell B $6$ of the Documentation worksheet. $-$ If cell B$6$ does not display your name, delete the file and download a new copy. PROJECT STEPS $1.$ Carmelo Miraglia is an executive consultant at Tallridge Regional Medical Center. organization. Change the theme of the workbook to Office. $2.$ On the Departments worksheet, change the width of columns C through H to $12.00$ characters. $3.$ Change the height of row $1$ to $21$ points. $4.$ Merge and center the contents of the range A $2$: $12.5.$ Format the merged range A $2$: $12$ as described below: a$.$ Apply the $40\%-$ Accent $5$ cell style. b$.$ Apply bold formatting. c$.$ Change the font size to $14.6.$ Enter the values shown in Table $1$ into the corresponding cells in the range A$5$:E$5.$ Table $1$: Data for the Range A$5$:E$57.$ Format the range A$5$:$15$ as described below: a$.$ Center cell contents. b$.$ Change the font size to $11$ pt$.$ c$.$ Change the background color to Blue, Accent $5,$ Lighter $40\%(9$th column, $4$ th row of the Theme Colors palette$).$ d$.$ Apply Wrap Text to the text in each cell. $8.$ Select the range A$6$: J$14$ and then add a White, Background $1$ border to all sides of each cell. $9.$ Select the range A $14$: J $14$ and then add a thin top border to each cell using the Automatic color. $10.$ Select the range H $6$: H $13$ and then format the range as described below: a$.$ Format the range with the Percentage number format with zero decimal places. b$.$ Add a Highlight Cells conditional formatting rule that forlnats cells that are greater than $0\mathrm{.}24$ as light red fill with dark red text. $11.$ Select the range $16$: I $13$ and then use conditional formatting to add solid orange data bars. $12.$ Select the range J $6$: $113$ and then add top$/$bottom conditional formatting rules to format the top $10\%$ of values as green fill with dark green text and the bottom $10\%$ of values as light red fill with dark red text. $13.$ Enter a formula in cell M$7$ using the VLOOKUP function to find an exact match for the department abbreviation. Look up the department abbreviation $($cell M$6)$ using an absolute reference, search the staff table data $($the range A$6$:J$13)$ using an absolute reference, and return the department name $($the $2$ nd column$).14.$ Copy the formula in cell M $7$ to the range M $8$: M $15,$ and edit the copied formulas to retum the value from the column indicated by the label in column L$.15.$ In cell C$17,$ enter a formula using the TODAY function that displays the current date. $16.$ Delete column $0.17.$ Hide row $18.18.$ On the Budget worksheet, create a $2-$D pie chart based on the non$-$adjacent range A$5$:A$12$ and F$5$:F$12.$ Modify the chart as described below: a$.$ Resize and reposition the chart so that the upper$-$left corner is located within cell H $4$ and the lower$-$right corner is located within cell O $22.$ b$.$ Apply Chart Style $3$ to the chart. c$.$ Enter $2025$ Budget by Department as the chart title. $19.$ In the $2021$ Budget by Department $2-$D pie chart $($located in the range H$23$:O$43),$ make the following changes: a$.$ Change the data labels to display only the percentage and a label position of Center. b$.$ Reposition the legend on the right side of the chart$\mathrm{.}20.$ Update the Departmental Budget Comparison $2021-2025$ combo chart in the range A$15$:G$36$ as follows: a$.$ Change the minimum bound of the right vertical axis to $40,000,000.$ b$.$ Add axis titles to the chart. Use Department Budgets as the left vertical title, use Total Budget as the right vertical title, and remove the horizontal axis title. c$.$ Apply a shape fill to the chart using the Blue, Accent $5,$ Lighter $80\%$ fill color. $21.$ Delete the Hiring worksheet. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the website to submit your completed project.