Save the file NP$\_$EX$365\_2021\_4$b$\_$FirstLastName$\_1.$xIsx as

NP$\_$EX$365\_2021\_4$b$\_$FirstLastName$\_2.$xIsx

Edit the file name by changing $"1"$ to $"2".$

If you do not see the $.$xIsx file extension, do not type it$.$ The file extension will be added for you automatically.

With the file NP$\_$EX$365\_2021\_4$b$\_$FirstLastName$\_2.$xIsx 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

Kayla Rowe is an investment banker at Stuarts Bank in New York City. She is working with a software company called Caretaker Mobile Apps, which is developing an app that detects and manages smart devices in a customer's home. To help Caretaker Mobile Apps secure funding for its new product, Kayla is using an Excel workbook to analyze their expenses and funding options and to create charts that illustrate the analysis.

Switch to the Current Expenses worksheet. In the range E$5$:E$9,$ add Conditional Formatting to compare the Quarter $4$ expenses using Gradient Fill Blue Data Bars.

In the range $F5$:$F10,$ add Line sparklines based on the data in the range $B5$:$E10$ to compare each category of expense and total expenses from Quarter $1$ to Quarter $4.$

Apply the Red, Accent $6(10$th column, $1$st row in the Theme Colors palette$)$ sparkline color to the sparklines to contrast with the data in the worksheet.

Kayla created a pie chart comparing how each type of expense relates to the total expenses in Quarter $1.$ Modify the pie chart in the range G$4$:$022$ as follows to make it more meaningful:

a$.$ Enter Quarter $1$ Expenses as the chart title.

b$.$ Change the data labels to include the Category Name, and position the labels in the Inside End location to clarify what each piece represents.

c$.$ Remove the Legend from the chart because it now repeats information in the data