dl issues cannot be used as excuses to exter will be applie WA I Prvot Table (50%) 3 The Following is the results of the 2016 summer Olympies Games, Please answer the following questions a. Create a Privot table in a new sheet. Display Contry in Columns, Sport, Event (Under Sport in Rows, Medal in values and change the calculation to 4 is "values" doesn't show "Count of Medal". Show "Grand Total for Columns only." Rename this worksheets "Put A(294) 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 "values" doesn't show "Count of Medal". Insert Slicers for Country Abbreviation and Medal Using these to show only USA and Gold Medal. Reamet 15 worksheet as "Plvet B" (25%) 16 17 18 19 Sport 20 Archery Men's individu 21 Archery Women's Individual 22 Archery Men's Team 23 Archery Women's Team con 24 Artistic Gymnastics Men's individual Around 25 Artistic Gymnastics Men's Roorbe 26 Artistic Gymnastics Men's Pommel Horse 27 Artistic Gymnastics Men's Ring GRE 28 Artistic Gymnastics Men's Vault De 29 Arti Men's Parallel Bar Gymnastics 30 Artistic Gymnastics Men's Team IN 31 Artistic Gymnastics Wome individual 32 Artistic Gymnastics Women's wilt 33 Artistic Gymnastics Women's never New 34 Artistic Gymnastics Women's Balance Beam 35 Artistic Gymnastics Women's Forbes 36 Artistic Gymnastics Women USA 37 Artistic Gymnastics Man 100 38 Athletics + Sheet3 Pivot B Pivot A Sheet1 Sheet2 Select destination and press ENTER or choose Paste ko IN dl issues cannot be used as excuses to exter will be applie WA I Prvot Table (50%) 3 The Following is the results of the 2016 summer Olympies Games, Please answer the following questions a. Create a Privot table in a new sheet. Display Contry in Columns, Sport, Event (Under Sport in Rows, Medal in values and change the calculation to 4 is "values" doesn't show "Count of Medal". Show "Grand Total for Columns only." Rename this worksheets "Put A(294) 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 "values" doesn't show "Count of Medal". Insert Slicers for Country Abbreviation and Medal Using these to show only USA and Gold Medal. Reamet 15 worksheet as "Plvet B" (25%) 16 17 18 19 Sport 20 Archery Men's individu 21 Archery Women's Individual 22 Archery Men's Team 23 Archery Women's Team con 24 Artistic Gymnastics Men's individual Around 25 Artistic Gymnastics Men's Roorbe 26 Artistic Gymnastics Men's Pommel Horse 27 Artistic Gymnastics Men's Ring GRE 28 Artistic Gymnastics Men's Vault De 29 Arti Men's Parallel Bar Gymnastics 30 Artistic Gymnastics Men's Team IN 31 Artistic Gymnastics Wome individual 32 Artistic Gymnastics Women's wilt 33 Artistic Gymnastics Women's never New 34 Artistic Gymnastics Women's Balance Beam 35 Artistic Gymnastics Women's Forbes 36 Artistic Gymnastics Women USA 37 Artistic Gymnastics Man 100 38 Athletics + Sheet3 Pivot B Pivot A Sheet1 Sheet2 Select destination and press ENTER or choose Paste ko IN