Ch 2 Excel Labs Saved 4 Part 2 of 2 12.5 points eBook References Required information Lab 2.4 Alternate: Aggregating and Visualizing Different Data Types (LO 2-5) [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 2.4 to the Alt Lab 2.4 Data.xlsx dataset. The same scenario exists as before with the Sláinte brewery, only this time you are looking at the purchasing transactions (instead of sales). The raw materials that Sláinte orders are hops, barley, malt, wheat, and seasonal items. Required: 1. Create a pivot table and pivot chart to assess the sum of raw materials quantity purchased by year. 2. Create a slicer to interactively filter the pivot chart by state from which the products were ordered. 3. Adjust the pivot chart to show horizontal bars. Data: Alt Lab 2.4 Data.xlsx Analyze the Data: Alternate Labs don't have step-by-step instruction or video support. Apply your experience from the original lab. If needed, reference the text or eBook for instructions and steps from the original lab. Lab 2.4 Alternate: Assessment Questions Answer the following questions based on the details computed. Question 1. How many units of Hops were purchased in 2025? 2. Which product was purchased the most from suppliers in Minnesota (MN) in 2025? 3. How many units of Malt - Wheat were purchased from Arkansas suppliers in 2025? 4. How many units of Malt - Wheat were purchased from Washington (WA) suppliers in 2024? 5. How many units, total were purchased from Washington (WA) suppliers in 2025? Answer
Ch 2 Excel Labs Saved 4 Part 2 of 2 12.5 points eBook References Required information Lab 2.4 Alternate: Aggregating and Visualizing Different Data Types (LO 2-5) [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 2.4 to the Alt Lab 2.4 Data.xlsx dataset. The same scenario exists as before with the Sláinte brewery, only this time you are looking at the purchasing transactions (instead of sales). The raw materials that Sláinte orders are hops, barley, malt, wheat, and seasonal items. Required: 1. Create a pivot table and pivot chart to assess the sum of raw materials quantity purchased by year. 2. Create a slicer to interactively filter the pivot chart by state from which the products were ordered. 3. Adjust the pivot chart to show horizontal bars. Data: Alt Lab 2.4 Data.xlsx Analyze the Data: Alternate Labs don't have step-by-step instruction or video support. Apply your experience from the original lab. If needed, reference the text or eBook for instructions and steps from the original lab. Lab 2.4 Alternate: Assessment Questions Answer the following questions based on the details computed. Question 1. How many units of Hops were purchased in 2025? 2. Which product was purchased the most from suppliers in Minnesota (MN) in 2025? 3. How many units of Malt - Wheat were purchased from Arkansas suppliers in 2025? 4. How many units of Malt - Wheat were purchased from Washington (WA) suppliers in 2024? 5. How many units, total were purchased from Washington (WA) suppliers in 2025? Answer
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![Ch 2 Excel Labs
Saved
4
Part 2 of 2
12.5
points
eBook
References
Required information
Lab 2.4 Alternate: Aggregating and Visualizing Different Data Types (LO 2-5)
[The following information applies to the questions displayed below.]
Lab Insight: Apply the same steps in Lab 2.4 to the Alt Lab 2.4 Data.xlsx dataset. The same scenario exists as before with
the Sláinte brewery, only this time you are looking at the purchasing transactions (instead of sales). The raw materials that
Sláinte orders are hops, barley, malt, wheat, and seasonal items.
Required:
1. Create a pivot table and pivot chart to assess the sum of raw materials quantity purchased by year.
2. Create a slicer to interactively filter the pivot chart by state from which the products were ordered.
3. Adjust the pivot chart to show horizontal bars.
Data: Alt Lab 2.4 Data.xlsx
Analyze the Data: Alternate Labs don't have step-by-step instruction or video support. Apply your experience from the
original lab. If needed, reference the text or eBook for instructions and steps from the original lab.
Lab 2.4 Alternate: Assessment Questions
Answer the following questions based on the details computed.
Question
1. How many units of Hops were purchased in 2025?
2. Which product was purchased the most from suppliers in Minnesota (MN) in 2025?
3. How many units of Malt - Wheat were purchased from Arkansas suppliers in 2025?
4. How many units of Malt - Wheat were purchased from Washington (WA) suppliers in 2024?
5. How many units, total were purchased from Washington (WA) suppliers in 2025?
Answer](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F50426ab2-38d4-4dc1-896f-4fe89bbdba74%2F181e1f3f-0af7-46e4-b73b-0423914505fb%2Ftv5wiq3_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Ch 2 Excel Labs
Saved
4
Part 2 of 2
12.5
points
eBook
References
Required information
Lab 2.4 Alternate: Aggregating and Visualizing Different Data Types (LO 2-5)
[The following information applies to the questions displayed below.]
Lab Insight: Apply the same steps in Lab 2.4 to the Alt Lab 2.4 Data.xlsx dataset. The same scenario exists as before with
the Sláinte brewery, only this time you are looking at the purchasing transactions (instead of sales). The raw materials that
Sláinte orders are hops, barley, malt, wheat, and seasonal items.
Required:
1. Create a pivot table and pivot chart to assess the sum of raw materials quantity purchased by year.
2. Create a slicer to interactively filter the pivot chart by state from which the products were ordered.
3. Adjust the pivot chart to show horizontal bars.
Data: Alt Lab 2.4 Data.xlsx
Analyze the Data: Alternate Labs don't have step-by-step instruction or video support. Apply your experience from the
original lab. If needed, reference the text or eBook for instructions and steps from the original lab.
Lab 2.4 Alternate: Assessment Questions
Answer the following questions based on the details computed.
Question
1. How many units of Hops were purchased in 2025?
2. Which product was purchased the most from suppliers in Minnesota (MN) in 2025?
3. How many units of Malt - Wheat were purchased from Arkansas suppliers in 2025?
4. How many units of Malt - Wheat were purchased from Washington (WA) suppliers in 2024?
5. How many units, total were purchased from Washington (WA) suppliers in 2025?
Answer
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education