Required information Lab 4-1 Use PivotCharts to Visualize Declarative Data [The following information applies to the questions displayed below.] In this lab, you will focus on communicating your findings from chapter 2, Lab 2-2. Parts 1-4 of the IMPACT Model Part 5: Communicate Your Findings Refer to Chapter 4 for instructions and steps for each of the lab parts. Software needed Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data Slinte dataset 2 3 Row Labels Sum of Sales_Order_Quantity_Sold 4 Imperial IPA 61 5 Imperial Stout 258 6 IPA 235 7 Pale Ale 116 8 Stout 9 Wheat 10 Grand Total 11 12 190 119 979 Lab 4-1 Analysis Required: After completing Lab, specifically after creating the slicers, use the slicers to filter the data in order to answer the following questions: What quantity of Imperial Stout sold in December? What was the grand total (of all beers) sold in April? What quantity of Imperial IPA sold in December and January (combined)? Which product sold the most in November? Which products did not sell at all in February? Which product(s) did not sell at all in April