Question 1 Privot Table (50%) The Following is the results of the 2016 summer Olympics Games, Please answer the following questions a. Create a Privot table in a new sheet. Display Country in Columns, Sport, Event (Under Sport) in Rows, Medal in values and change the calculation to " count" if "values" doesn't show "Count of Medal". Show "Grand Total for Columns only." Rename this worksheet as "Pivot A" (25%) b. Create a Privot table in a new sheet. Display Country Abbreviation in Rows, Sport in Columns, Medal in values and change the calculation to " count" if "values" doesn't show "Count of Medal". Insert Slicers for Country Abbreviation and Medal. Using the slicers to show only USA and Gold Medal. Rename this worksheet as "Pivot B" (25%)