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

Pkg Acc Infor Systems MS VISIO CD
10th Edition
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:Ulric J. Gelinas
Chapter7: Controlling Information Systems: Introduction To Enterprise Risk Management and Internal Control
Section: Chapter Questions
Problem 1P
icon
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
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
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Pkg Acc Infor Systems MS VISIO CD
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L
Accounting Information Systems
Accounting Information Systems
Finance
ISBN:
9781337552127
Author:
Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:
Cengage Learning
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Essentials Of Business Analytics
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
SWFT Essntl Tax Individ/Bus Entities 2020
SWFT Essntl Tax Individ/Bus Entities 2020
Accounting
ISBN:
9780357391266
Author:
Nellen
Publisher:
Cengage
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning