Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Benicio started to define names for cells and ranges in the All Locations worksheet to make it easy to identify the total sales
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 and use defined names as follows: a. Create a defined name for the Waterproof sales amounts (range B7:E7) using Waterproof Total as the name. b. c. d. In cell FS, enter a formula using the SUM function to display the total of the sales amounts in the Mini Total range. In cell F6, enter a formula using the SUM function to display the total of the sales amounts in the Voice Activated_Total range. In cell F7, enter a formula using the SUM function to display the total of the sales amounts in the Waterproof Total range. CENGAGE New Perspectives Excel 365/2021 | Modules 5-8: SAM Capstone Project la 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 as follows: a. Open the workbook Support EX365_2021_CS5-8a_2023.xlsx. b. Return to the All Locations worksheet in the original workbook. C d. e. f. 5. In cell GS, enter a formula using an external reference to display the total sales of Mini products in 2023 (cell F5). In the formula in cell G5, change the absolute reference to a mixed reference, with a relative reference to the row number. Fill the range G6:G8 with the formula in cell GS, filling without formatting. Close the workbook Support EX365_2021 CS5-8a_2023.xlsx In the range B12:E12, Benicio wants to display a rating depending on the total sales for each quarter. He listed the rating criteria in the range A14:F15. For example, if total sales in Quarter 1 are between $5900 and $5999, the Performance rating is Good.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started