1. Create a PIVOT table to answer the question. How many records meet the following criteria: Origin State is Hawaii and the Flight is not cancelled. 2. Use Advanced Filters only to answer the question. Filter the list in place. Keep the results or no marks will be rewarded. How many records meet the following criteria: Age is more than 40 and No of Flights per Annum is more than 30 and Type of Travel is Business Travel; OR Flight Cancelled is Yes. OR Airline Status is Gold. 3. Use Simple Filters to answer the following question: How many records meet the following criteria: Arrival Delay greater 5 mins is No and Destination State is Alaska or Arizona or Arkansas or Louisiana and Flight Distance is less than 1500. Record your answer and then clear the filter. 4. In cell AE12 use the IF function to enter long if the Flight Time in Minutes is greater than 140 otherwise the cell should be blank. Copy the function to the other cells in the column. In cell AE1 use the appropriate function to calculate how many records have long. (format as comma style 0 decimal). 5. In cell AD12 use the IF function to enter Yes if the Departure Delay in Minutes is greater than 60 otherwise the cell should be blank. Copy the function to the other cells in the column. In cell AD1 use the appropriate function to calculate how many records have Yes. (format as comma style 0 decimal)

9 No of Flights per annum lo Satisfaction Airline Status Age Gender Class Class Price Year of Sensitivity First Flight Month % of Flight with other Airlines Type of Travel Shopping Amount at Airport Day of Month 28 4.5 31 41 0 1 2 7 3 56 8 15 4 2.5 Business Business Business 18 11 25 2 7 11 12 13 14 15 16 17 18 9 14 0 10 1 3 1 1 1 2 2 9 Eco 20 4 5 1 2007 2006 2006 2007 2006 2010 . 2011 w 2010 2003 10 75 60 135 45 26 65 60 90 8 Eco 25 0 15 5 4 0 Eco Blue Blue Blue Blue Silver Gold Gold Silver Blue Blue Blue Blue Platinum 21 43 49 49 35 33 44 51 16 Male Male Female Male Male Female are Male Male Female Female Male Female Female 3.5 Business travel Business travel wave Personal Travel non Business travel Business travel Business travel Business travel Business travel nesave Business travel wancave Business travel business travel Business travel Business travel Business travel Eco Eco 19 4 4 0 0 0 4 8 12 37 17 1 1 1 1 1 1 1 1 1 Eco 20 21 22 23 24 4 5 17 6 7 33 8 24 6 5 5 21 19 19 1 3 2 2 1 1 1 1 3 2 1 4 90 80 60 75 75 2005 2009 2005 2012 Eco CLO Eco 25 130 0 28 39 46 29 Eco 2 5 4 13 0 Eco 15 Do I need to provide information about previous post-secondary education? You must fully disclose all post-secondary education that you have attended or are currently attending, including studies that you passed and failed. Withholding information can result in offers being rescinded or students being withdrawn from the program. Students cannot declare previous education after they are admitted and retroactive transfer credit requests will not be considered. Shot Screen Shot 32 PM 2020-12...5.12 PM