Get fast, custom help from our academic experts, any time of day.
Place your order now for a similar assignment and have exceptional work written by our team of experts.
Secure Original On Schedule
Question 2
Use COUNTIF to answer the following question:
How many records meet the following criteria: Day of Month is more than 15. (Format as comma style 0 decimal)
Question 3
Use AVERAGEIFto answer the following question:
What is the average Eating and Drinking at Airport for records that meet the following criteria?: Gender is Male. (Format as comma style 2 decimals)
Question 4
Use AVERAGEIFto answer the following question:
What is the average Number of Flights per Annum for records that meet the following criteria?: Type of Travel is Business Travel. (Format as comma style 2 decimals)
Question 5
Use SUMIFto answer the following question:
What is the total Shopping Amount at Airport for records that meet the following criteria: Age is 40 or more. Format as comma style, 0 decimals
Question 6
Use SUMIFto answer the following question:
What is the total Number of Flights per Annum for records that meet the following criteria: Type of Travel is Personal Travel. (Format as comma style 0 decimal)
Question 7
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)
Question 8
In cell AE12 use the IF function to enter long if the Flight Time in Minutes is greater than 160 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)
Question 9
Use Simple Filters to answer the following question:
How many records meet the following criteria: Arrival Delay greater 5 mins is Yes and Destination State is Alaska or Arizona or Arkansas or Louisiana and Flight Distance is more than 1200.
Record your answer and then clear the filter.
Question 10
Create a PIVOT tableto answer the question.
How many records meet the following criteria: Month is 3 and the Origin City is Atlanta or New York or Newark.
Question 11
Use Advanced Filtersonly 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 lower than 55 and No of Flights per Annum is lower than 30 and Type of Travel is Personal Travel OR Flight Cancelled is Yes and Airline Status is Blue.
Get fast, custom help from our academic experts, any time of day.
Secure Original On Schedule