GETTING STARTED $-$ Open the file NP$\_$EX$19\_$CS$1-4$b$\_$FirstLastName$\_1.$xisx, avallable for download from the SAM website. $-$ Save the file as NP$\_$EX$19\_$CS$1-4$b$\_$FirstLastName$\_2.$xisx by changing the $"1"$ to a $"2".$ If you do not see the x xisx file extension in the Save As dialog box, do not type it$.$ The program will add the file extension for you automatically. $-$ With the file NP$\_$EX$19\_$CS$1-4$b$\_$FirstLastName$\_2.$xisx still open, ensure that your first and last name is displayed in cell B$6$ of the Documentation sheet. $-$ If cell B$6$ does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS $1.$ Abdul Rassim is a financial analyst for the Saxon Municipal Government. Abdul is buliding a workbook that summarizes budget and staffing data for the city. Change the theme of the workbook to Office. $2.$ On the Employees worksheet, change the width of columns D through I to $11.00$ characters. $3.$ Change the height of rows $2$ and $6$ to $30$ points. $4.$ Merge and center the contents of the range B$3$:K$3.5.$ Format the merged range B $3$: K $3$ as described below: a$.$ Apply the $40\%-$ Accent $2$ cell style. b$.$ Apply bold formatting. c$.$ Change the font size to $12.6.$ Enter the values shown in Table $1$ into the corresponding cells in the range B$6$:F$6.$ Table $1$: Data for the Range B$6$:F$67.$ Format the range B $6$: K $6$ as described below: a$.$ Center cell contents. b$.$ Change the font size to $11$ point. c$.$ Change the background color to Orange, Accent $2,$ Lighter $80\%(6$ th column, $2$nd row on the Theme Colors palette$).$ d$.$ Apply Wrap Text to the text in cell K $6.8.$ Select the range B$7$:K$17$ and then add a Light Gray, Background $2,$ Darker $10\%(2$nd row, $3$rd column in the Theme Colors palette$)$ border to all sides of each cell. $9.$ Select the range B$18$:K$18$ and then add a thin top border to each cell using Orange, Accent $2(1$st row, $6$ th column in the Theme Colors palette$).10.$ Select the range $17$:I$17$ and then format the range as dirscribed below: a$.$ Format the range with the Percentage number format with zero decimal places. b$.$ Add a Highlight Cells conditional formatting rule that formats cells that are greater than $20\%$ as Light Red Fill with Dark Red Text. $11.$ Select the range $37$:$317$ and then use conditional formatting to add gradient fill red data bars. $12.$ Select the range K$7$:K$17$ and then add top$/$bottom conditional formatting rules to format. the top $5\%$ of values as Green Fill with Dark Green Text and the bottom $5\%$ of values as Light Red Fill with Dark Red Text. $13.$ Enter a formula in cell NB using the VLOOKUP function to find an exact match for the department code, Look up the department code $($cell N$7)$ using an absolute reference, search the employee table data $($the range B$7$:K$17)$ using absolute references, and return the department name $($the $2$ nd column$).14.$ Copy the formula in cell NB to the range N$9$:N$16,$ pasting the formula only, and then edit the copied formulas to return the value from the column indicated by the label in column M$.15.$ In cell D$21,$ enter a formula using the TODAY function that displays the current date. $16.$ Delete column P$.17.$ Hide row $22.18.$ On the Department Comparison worksheet, create a $2-$D ple chart based on the nonadjacent range B$12$:B$16$ and F$12$:F$16.$ Modify the chart as described below: a$.$ Resize and reposition the chart so that the upper$-$left corner is located within cell $34$ and the lower$-$right corner is located within cell P$17.$ b$.$ Apply Chart Style $4$ to the chart. c$.$ Enter Bottom Five Depts $-2022$ as the chart title. Accessibility: Investigate$16.$ Delete column P$.17.$ Hide row $22.18.$ On the Department Comparison worksheet, create a $2-$D ple chart based on the nonadjacent range B $12$: B $16$ and F $12$: F $16.$ Modify the chart as described below: a$.$ Resize and reposition the chart so that the upper$-$left corner is located within cell $34$ and the lower$-$right comer is located within cell P$17.$ b$.$ Apply Chart Style $4$ to the chart. c$.$ Enter Bottom Five Depts $-2022$ as the chart title. $19.$ In the Bottom Five Depts $-20192-$D pie chart $($located in the range J$19$:P$38),$ make the following changes: a$.$ Change the data labels to display only the percentsge and a label position of Inside End. b$.$ Reposition the legend on the right side of the chart. New Perspectives Excel $2019$ I Modules $1-4$: SAM Copstone Project $1620.$ Update the Top Five Departments column chart in the range B$19$:H$39$ as follows: a$.$ Change the maximum bound of the left vertical axis to $13,000,000.$ b$.$ Add axis titles to the chart. Use Budgeted $ 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 plot area using the Gray, Accent $3,$ Lighter $80\%$ fill color. $21.$ Delete the Projections worksheet. Your workbook should look like the Final Figures on the following pages, Save your changes, dose the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.