Shelly Cashman Excel 2019 | Modules 4-7: SAM Critical Thinking Capstone Project 1c | Victoria Streaming Service | SC_EX19_CT_CS4-7c

#ShellyCashmanExcel 2019 #Excel 2019 #Modules 4-7 #Modules4-7:SAMCriticalThinkingCapstoneProject1c #SAMCriticalThinkingCapstoneProject1c #CapstoneProject1c #Project1c #SC_EX19_CT_CS4-7c #VictoriaStreamingService


Contact Me:
WhatsApp : +92 3115298219
Email : [email protected]

Direct WhatsApp Link:
https://tinyurl.com/4wjb4d63







#Shelly Cashman Excel 2019 | Modules 4-7: SAM Critical Thinking Capstone Project 1c
#Shelly Cashman Excel 2019
#Cashman Excel 2019
#Excel 2019
#Modules 4-7: SAM Critical Thinking Capstone Project 1c
#Modules 4-7
#SAM Critical Thinking Capstone Project 1c
#Critical Thinking Capstone Project 1c
#Thinking Capstone Project 1c
#Capstone Project 1c
#Project 1c
#SC_EX19_CT_CS4-7c
#Victoria Streaming Service


PROJECT STEPS
1. Bao Phan is a financial analyst for Victoria Streaming Service (VSS), a website that streams movies and TV shows to subscribers in the United States, Canada, and the United Kingdom. He is tracking sales for the year and asks for your help in projecting future sales and visualizing the sales data. The U.S., Canada, and U.K. worksheets have the same structure and contain similar data. Group the U.S., Canada, and U.K. worksheets to make changes to the three worksheets at the same time. The first change is to display today's date.
In the cell to the right of the cell labeled "Date", use a function to display today's date without the time.
2. Fill the row under 2022 Revenue Projections with the remaining quarters in the year.
3. VSS has applied a goal of increasing revenue to $90,000 in the fourth quarter of 2022. For Quarter 1, Bao estimates $84,309 in revenue, which is the average revenue per quarter from the current year.
Project the revenue in Quarters 2 and 3 by filling the series for the first projection with a linear trend.
4. Bao is confident that revenue will increase by at least 2 percent per quarter in 2022. He wants to calculate these revenue goals in a second projection.
Project the revenue for 2022 in the second projection based on a 2 percent growth series. Ungroup the worksheets.
5. Bao wants to consolidate the sales data in the U.S., Canada, and U.K. worksheets on the All Locations worksheet.
Go to the All Locations worksheet, and then consolidate the data. Use a function and 3D references to total the revenue from Action movies in Quarter 1 in the U.S., Canada, and U.K. Use the formula to calculate the remaining revenues from the other types of movies for all four quarters, pasting the formula only.
6. Bao wants to round the total sales values so that they are easier to remember.
In the appropriate cell, use a function to display the total sales for Quarter 1 rounded up to a whole number. Fill the remaining totals using the formula from Quarter 1.