New Perspectives Excel Modules 5-8 SAM Critical Thinking Capstone Project 1c NewSight Consulting

If you directly want to get the project from us then contact us on Whatsapp. Click on link below👇👇
wa.me/message/...
Whatsapp Contact Number:
[phone]
Email ID:
[e-mail]
New Perspectives Excel 365/2021 | Modules 5-8 SAM Critical Thinking Capstone Project 1c | NewSight Consulting
1. "Benicio Cortez is a financial consultant with NewSight Consulting in Denver, Colorado. He is working with DIG Technology, a company that sells five models of portable speakers to consumers in North America. In an Excel workbook, Benicio is analyzing the performance of each speaker model and projecting sales for a new product. He asks for your help in completing the analysis.
Go to the U.S. worksheet. Benicio has received annual sales worksheets from the main offices in the three countries where DIG Technology sells products: the United States, Canada, and Mexico. The worksheets for the countries have a similar structure.
Complete the worksheets by using a function to total the Mini sales amounts for Q1 through Q4 in the U.S., Canada, and Mexico worksheets. Fill the formula down to display the remaining totals for each type."
Create a formula using a function.
Create a formula using a function.
Create a formula using a function.
Copy a formula into a range.
Copy a formula into a range.
Copy a formula into a range.
2. "Go to the All Locations worksheet, where Benicio wants to summarize the quarterly and annual totals from the three locations for each type of product. Consolidate the sales data from the three locations.
Use a function to total the Mini sales values in Q1 from the U.S., Canada, and Mexico worksheets. Use the same formula to consolidate and fill the remaining product totals in the table through Q4."
Create a formula using a function.
Copy a formula into a range.
Copy a formula into a range.
3. "Benicio started to define names for cells and ranges in the All Locations worksheet to make it easy to identify the total sales for each product. He wants you to add a defined name for the Waterproof sales amounts and then find the total annual sales for each product.
Create a defined name for the Waterproof sales amounts from Q1 through Q4 using Waterproof_Total as the name. Use a function to display the total of the sales amounts in the Mini_Total range in the Total column. Use the same function to total the Voice_Activated_Total range and the Waterproof_Total range in the appropriate cells."
Create a defined name for a range.
Create a formula using a function.
Create a formula using a function.
Create a formula using a function.
4. "Benicio wants to compare the sales of each product in 2024 with the sales in 2023. He has the 2023 sales data stored in a separate workbook. Add the 2023 sales data to the All Locations worksheet.
Use a reference to pull in the total sales of Mini products in 2023 from the Support_EX365_2021_CT_CS5-8c_2023.xlsx workbook. Make sure the formula always references the same column but not the same row, and then fill the rest of the 2023 totals with the formula, but not the formatting."
Create links to an external workbook.
Create a formula using a function.
Copy a formula into a range.
5. In the appropriate cell, use a function to look up the value in the Total sales column for Q1. Retrieve the performance rating from the table showing the revenue amounts and ratings. The formula should always use the exact range and find an approximate match. Use the formula to display the performance ratings for the rest of the quarters.