New Perspectives Excel 365/2021 | Module 4: SAM Project 1b |

#NewPerspectivesExcel365/2021Module4SAMProject1b #SAMProject1b #New_Perspectives_Excel_365_2021_Module_4_SAM_Project_1b #Module4SAMProject1b #Module_4_SAM_Project_1b #SAM_Project_1b #ExcelModule04 #NP_EX365_2021_4b_FirstLastName_1.xlsx #NP_EX365_2021_4b #NewPerspectives #New_Perspectives #SAMProject1bExcelModule04AnalyzingandChartingFinancialData #SAM_Project_1b_Excel_Module_04_Analyzing_and_Charting_Financial_Data


Contact Me For Your Assignments and Courses
WhatsApp: +923096000718
Email :myitlabexpert@gmail.com
WhatsApp Direct Link: https://wa.link/7s2pnw


#New Perspectives Excel 365/2021 | Module 4: SAM Project 1b
#NewPerspectivesExcel365/2021Module4SAMProject1b
#New_Perspectives_Excel_365_2021_Module_4_SAM_Project_1b
#SAM Project 1b Excel Module 04 Analyzing and Charting Financial Data
#SAMProject1bExcelModule04AnalyzingandChartingFinancialData
#SAM_Project_1b_Excel_Module_04_Analyzing_and_Charting_Financial_Data
#SAM Project 1b Excel Module 04
#SAMProject1bExcelModule04
#SAM_Project_1b_Excel_Module_04
#Module 4: SAM Project 1b
#Module4SAMProject1b
#Module_4_SAM_Project_1b
#Excel Module 4 SAM Project B
#Excel_Module_4_SAM_Project_B
#ExcelModule4SAMProjectB
#Excel Module 4 SAM Project 1b
#Excel_Module_4_SAM_Project_1b
#ExcelModule4SAMProject1b
#Excel Module 4 SAM Project 1b Stuarts Bank
#Excel_Module_4_SAM_Project_1b_Stuarts_Bank
#ExcelModule4SAMProject1bStuartsBank
#Stuarts Bank
#Stuarts_Bank
#StuartsBank
#ANALYZEANDCHARTFINANCIALDATA
#ANALYZE AND CHART FINANCIAL DATA
#ANALYZE_AND_CHART_FINANCIAL_DATA
#NP_EX365_2021_4b_FirstLastName_1.xlsx
#NP_EX365_2021_4b_FirstLastName_1.xlsx
#NP_EX365_2021_4b
#Cengage
#NP
#EX365_2021
#EX365


#New Perspectives Excel 365/2021 | Module 4: SAM Project 1b

PROJECT STEPS
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.
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.
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.
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.
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.


#NewPerspectivesExcel365/2021Module1SAMProject1a
#NewPerspectivesExcel365/2021Module1SAMProject1b
#NewPerspectivesExcel365/2021Module2SAMProject1a
#NewPerspectivesExcel365/2021Module2SAMProject1b
#NewPerspectivesExcel365/2021Module3SAMProject1a
#NewPerspectivesExcel365/2021Module3SAMProject1b
#NewPerspectivesExcel365/2021Module4SAMProject1a
#NewPerspectivesExcel365/2021Module4SAMProject1b
#NewPerspectivesExcel365/2021Module5SAMProject1a
#NewPerspectivesExcel365/2021Module5SAMProject1b
#NewPerspectivesExcel365/2021Module6SAMProject1a
#NewPerspectivesExcel365/2021Module6SAMProject1b
#NewPerspectivesExcel365/2021Module7SAMProject1a
#NewPerspectivesExcel365/2021Module7SAMProject1b
#NewPerspectivesExcel365/2021Module8SAMProject1a
#NewPerspectivesExcel365/2021Module8SAMProject1b
#NewPerspectivesExcel365/2021Module9SAMProject1a
#NewPerspectivesExcel365/2021Module9SAMProject1b
#NewPerspectivesExcel365/2021Module10SAMProject1a
#NewPerspectivesExcel365/2021Module10SAMProject1b
#NewPerspectivesExcel365/2021Module11SAMProject1a
#NewPerspectivesExcel365/2021Module11SAMProject1b
#NewPerspectivesExcel365/2021Module12SAMProject1a
#NewPerspectivesExcel365/2021Module12SAMProject1b