Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Bao wants to consolidate the sales data in the S., Canada, and U.K. worksheets on the All Locations worksheet. Ungroup the worksheets, go to the All Locations worksheet, and then consolidate the data as follows: In cell B6, enter a formula using the SUM function and a 3D reference to total the revenue from Action movies in Quarter 1 (cell B6) in the U.S., Canada, and U.K. Copy the formula in cell B6 to calculate the revenue from the other types of movies for all four quarters (range B7:B11 and C6:E11), pasting the formula only.

Bao wants to consolidate the sales data in the S., Canada, and U.K. worksheets on the All Locations worksheet. Ungroup the worksheets, go to the All Locations worksheet, and then consolidate the data as follows: In cell B6, enter a formula using the SUM function and a 3D reference to total the revenue from Action movies in Quarter 1 (cell B6) in the U.S., Canada, and U.K. Copy the formula in cell B6 to calculate the revenue from the other types of movies for all four quarters (range B7:B11 and C6:E11), pasting the formula only.

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
See similar textbooks
icon
Related questions
Question

 

  1. Bao wants to consolidate the sales data in the S., Canada, and U.K. worksheets on the All Locations worksheet.

    Ungroup the worksheets, go to the All Locations worksheet, and then consolidate the data as follows:
    1. In cell B6, enter a formula using the SUM function and a 3D reference to total the revenue from Action movies in Quarter 1 (cell B6) in the U.S., Canada, and U.K.
    2. Copy the formula in cell B6 to calculate the revenue from the other types of movies for all four quarters (range B7:B11 and C6:E11), pasting the formula only.
AutoSave SC EX19_CS4-7a_AlexisDonald_2 - Saved - P Search 困 Off Alexis Donald AD File Home Insert Page Layout Formulas Data Review View Help Тeam A Share P Comments X Cut - A A 60% - Acce... Accent1 Accent3 E AutoSum v - 11 == ab Wrap Text Accounting Accent2 TTX Trebuchet MS LE Copy Fill v Conditional Format as Accent4 Formatting Accent5 Sort & Find & Filter v Select v Paste в IU =E EE E E Merge & Center $ - % 9 Accent6 Comma Insert Delete Format O Clear Analyze S Format Painter Table Data Clipboard Font Alignment Number Styles Cells Editing Analysis B6 fe A C D E G H K P Q R Victoria Streaming Service 1 2 All Locations 3 in 000s 4 2021 Revenue 5 Туре 6 Action 7 Animation Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 8 Comedy - 9 Drama 10 Foreign 11 TV shows 12 Total 's 13 14 Total revenue last year: 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Documentation U.S. Canada U.K. All Locations Original Content Subtotals Expansion Funding 田 回 四 Enter 100% 11:44 AM O Type here to search 66°F Cloudy A G 4) 11/1/2021 尔 近
Transcribed Image Text:AutoSave SC EX19_CS4-7a_AlexisDonald_2 - Saved - P Search 困 Off Alexis Donald AD File Home Insert Page Layout Formulas Data Review View Help Тeam A Share P Comments X Cut - A A 60% - Acce... Accent1 Accent3 E AutoSum v - 11 == ab Wrap Text Accounting Accent2 TTX Trebuchet MS LE Copy Fill v Conditional Format as Accent4 Formatting Accent5 Sort & Find & Filter v Select v Paste в IU =E EE E E Merge & Center $ - % 9 Accent6 Comma Insert Delete Format O Clear Analyze S Format Painter Table Data Clipboard Font Alignment Number Styles Cells Editing Analysis B6 fe A C D E G H K P Q R Victoria Streaming Service 1 2 All Locations 3 in 000s 4 2021 Revenue 5 Туре 6 Action 7 Animation Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 8 Comedy - 9 Drama 10 Foreign 11 TV shows 12 Total 's 13 14 Total revenue last year: 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Documentation U.S. Canada U.K. All Locations Original Content Subtotals Expansion Funding 田 回 四 Enter 100% 11:44 AM O Type here to search 66°F Cloudy A G 4) 11/1/2021 尔 近
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 6 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS