Objective: Upon completion of this activity, you will be able to create a Pivot Table Students Instructions: 1. In a new Excel spreadsheet, develop the following set of data. 2. Download the data in Activity 3.1 Oslo Travel Agents. 3. Create a pivot table from this data. 4. Use the filters within to view the average prices of holidays that have a Travel Method of Plane and a Resort Name that begins with the letter M. 5. This activity has a value of 15 points. 6. Submit by Assignment on Blackboard. 7. The deadline for the test can be found in "Calendar" located in "Tools" in the Blackboard platform. OSLO TRAVEL AGENTS Metho Holiday Australia Australia Travel Price for Country Resort Hotel Name # of days Australia Great Bamer Reef Plane CH2H S 14500 Chile Santiago Plane AA2369A $ 131.00 Australia Pem Plane A845898 $ 130,00 England London Train AC9841C $ 141.00 England Baywater Train CD1234D $ 137.00 France Toulouse Coach CE6514E $ 135.00 France Pons Plane CF5142F $ 141.00 France Nice Plane EA0216A $ 145.00 Nice Plane EB9951B $ 125.00 Pern Coach EC7845C $ 120.00 Perth Coach PL1564 $ 9800 Spain Sevile Train PQ74560 $ 95.00 Spain Meded Train PR9945R $ 93.00 Spain Malaga Coach PS1208S $ 100.00 Spain Toledo Plane TA1278A $ 10.00 Granada Plane TB6211B $ 107.00 Spain Barcelona Plane TC2018 $ 109.00 Spain Barcelona Plane H147121 $ 95.00 Spain Madrid Coach HJ03690 $111.00 Trinidad Port of Spain Coach HK3081K $ 120.00 England Baywater Train WS9610S $141.00 Germany Meininger Train WT0287T $ 150.00 Chile Santiago 1 22 Plane WU34120 $ 135.00 Chile 21 Plane WV6510 $ 132.00 Denmark Copenhagen 19 Plane 0064120 $ 130.00 Denmark Copenhagen Plane OU86520 $ 127.00 Figure 13: Oslo Travel Agents data for activity. Source: Andino, D., 2019 Spain Santiago Objective: Upon completion of this activity, you will be able to create a Pivot Table Students Instructions: 1. In a new Excel spreadsheet, develop the following set of data. 2. Download the data in Activity 3.1 Oslo Travel Agents. 3. Create a pivot table from this data. 4. Use the filters within to view the average prices of holidays that have a Travel Method of Plane and a Resort Name that begins with the letter M. 5. This activity has a value of 15 points. 6. Submit by Assignment on Blackboard. 7. The deadline for the test can be found in "Calendar" located in "Tools" in the Blackboard platform. OSLO TRAVEL AGENTS Metho Holiday Australia Australia Travel Price for Country Resort Hotel Name # of days Australia Great Bamer Reef Plane CH2H S 14500 Chile Santiago Plane AA2369A $ 131.00 Australia Pem Plane A845898 $ 130,00 England London Train AC9841C $ 141.00 England Baywater Train CD1234D $ 137.00 France Toulouse Coach CE6514E $ 135.00 France Pons Plane CF5142F $ 141.00 France Nice Plane EA0216A $ 145.00 Nice Plane EB9951B $ 125.00 Pern Coach EC7845C $ 120.00 Perth Coach PL1564 $ 9800 Spain Sevile Train PQ74560 $ 95.00 Spain Meded Train PR9945R $ 93.00 Spain Malaga Coach PS1208S $ 100.00 Spain Toledo Plane TA1278A $ 10.00 Granada Plane TB6211B $ 107.00 Spain Barcelona Plane TC2018 $ 109.00 Spain Barcelona Plane H147121 $ 95.00 Spain Madrid Coach HJ03690 $111.00 Trinidad Port of Spain Coach HK3081K $ 120.00 England Baywater Train WS9610S $141.00 Germany Meininger Train WT0287T $ 150.00 Chile Santiago 1 22 Plane WU34120 $ 135.00 Chile 21 Plane WV6510 $ 132.00 Denmark Copenhagen 19 Plane 0064120 $ 130.00 Denmark Copenhagen Plane OU86520 $ 127.00 Figure 13: Oslo Travel Agents data for activity. Source: Andino, D., 2019 Spain Santiago