No of Flights per annum lo Satisfaction Airline Status Age Gender Class Class Price Year of Sensitivity First Flight Month.

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.