Скачать или смотреть New Perspectives Excel 365/2021 | Module 4: SAM Project 1b Stuarts Bank

New Perspectives Excel 365/2021 | Module 4 SAM Project 1b #newperspectives #module4 #samproject1b

If you directly want to get the project from us then contact us on our Whatsapp. Link is given below,

https://wa.me/message/PPXGSJS2TLWUA1

Whatsapp Contact Number:
+91 8114420233

Email ID:
[email protected]

1. "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 E5:E9, add Conditional Formatting to compare the Quarter 4 expenses using Gradient Fill Blue Data Bars."
Apply a conditional formatting rule that uses data bars.
Change the fill color of conditional formatting data bars.
2. 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.
Add sparklines to cells.
3. Apply the Red, Accent 6 (10th column, 1st row in the Theme Colors palette) sparkline color to the sparklines to contrast with the data in the worksheet.
Set the color of a sparkline.
4. "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 G4:O22 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 labels."
Insert a chart title.
Change the data label options.
Change the position of the data labels.
Remove a legend from a chart.
5. "Kayla also wants to compare how each type of expense relates to the total expenses in Quarter 4. Create a chart as follows to compare the expenses:
a. Create a 2-D Pie chart based on data in the nonadjacent ranges A5:A9 and E5:E9.
b. Resize and reposition the chart so that the upper-left corner is located within cell G23 and the lower-right corner is located within cell O39, then left-align the chart with the pie chart above it in the range G4:O22."
Insert a chart.
Resize and reposition a chart.
6. "Customize the new pie chart in the range G23:O39 as follows to clarify its purpose and match the format of the other pie chart:
a. Enter Quarter 4 Expenses as the chart title.
b. Apply Style 11 to the chart."
Insert a chart title.
Change the chart style.
7. "Kayla also wants to compare the five types of expenses in each quarter. Create a chart as follows to provide this information:
a. Create a Stacked Bar chart based on the data in the range A4:E9.
b. Resize and reposition the chart so that the upper-left corner is located within cell A11 and the lower-right corner is located within cell F28."
Insert a chart.
Resize and reposition a chart.
8. "Customize the stacked bar chart in the range A11:F28 as follows to make it easier to interpret:
a. Enter Expenses per Quarter as the chart title.
b. Change the Maximum value to $1,400,000 on the horizontal axis.
c. Apply a shape fill of Indigo, Text 2, Lighter 80% (4th column, 2nd row in the Theme Colors palette) to the chart to contrast with the other charts in the worksheet."
Insert a chart title.
Change the maximum bounds of the vertical axis.
Change the fill color of a chart area.
9. "Kayla wants the Projected Expenses 2022 – 2025 combo chart to appear on a different worksheet. Move the chart as follows:
a. Move the combo chart in the range A35:F62 to the Projected Expenses worksheet.
b. Resize and reposition the chart so that the upper-left corner is located within cell A12 and the lower-right corner is located within cell J35."