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. In cell G5, enter a formula using an external reference to display the total sales of Mini products in 2023 (cell F5). d. In the formula in cell G5, change the absolute reference to a mixed reference, with a relative reference to the row number. e. Fill the range G6:G8 with the formula in cell G5, filling without formatting. f. Close the workbook Support_EX365_2021_CS5-8a_2023.xlsx.
Added by Veronica P.
Close
Step 1
xlsx. This workbook contains the sales data for the year 2023 that you need. Show more…
Show all steps
Your feedback will help us improve your experience
Andreas Papavassiliou and 65 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Scrub Jay Peripherals Sales Projections Yearly Sales Projections (units) Year-over-year growth estimate 5% 10% 15% 20% 25% 30% 35% 2021 10000 10000 10000 10000 10000 10000 10000 2022 2023 2024 2025
Akash M.
Olivia wants to consolidate the sales data in the United States, Canada, and Australia on the All Locations worksheet. Ungroup the worksheets, go to the All Locations worksheet, and then consolidate the data as follows: a. In cell B6, enter a formula using the SUM function and a 3D reference to total the number of downloads of Adventure audio books in January. Copy the formula in cell B6 to calculate the number of downloads for the other months in the United States, Canada, and Australia. In cell B16, enter a formula using the SUM function and a 3D reference to total the sales of Adventure audio books in January. Copy the formula in cell B16 to calculate the sales for the other types of books and months. The ranges for the other types of books are B17:B21 and the months are C16:E21. Paste the formula only.
Edra wants to consolidate the data from each of the regions. Switch to the Consolidated Sales worksheet, then update the worksheet as follows: a. In cell A6, enter a formula without using a function that references cell A6 in the Washington worksheet. b. Copy the formula from cell A6 to the range A7:A9 without copying the formatting. c. In cell B6, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B6 in the Idaho:Washington worksheets. d. Copy the formula from cell B6 to the range B7:B9 without copying the formatting. e. Then copy the formulas and the formatting from the range B6:B9 to the range C6:E9.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD