Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of Accounting for Governmental and Not-for-Profit Organizations

Authors: Paul A. Copley

10th Edition

007352705X, 978-0073527055

More Books

Students also viewed these Accounting questions

Question

Discuss the relationship between finance and economics.

Answered: 1 week ago

Question

How are Internet standards developed?

Answered: 1 week ago