answer on the excel shit

 

1. How many records meet the following criteria: Day of Month is more than 30. (Format as comma style 0 decimal)

2.Use AVERAGEIFto answer the following question:

.

What is the average Eating and Drinking at Airport for records that meet the following criteria?: Class is Business. (Format as comma style 2 decimals)

3.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 Mileage Tickets. (Format as comma style 2 decimals)

.

4.Use SUMIFto answer the following question:

.

What is the total Shopping Amount at Airport for records that meet the following criteria: Age is 50 or less. Format as comma style, 0 decimals

5.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)

6.In cell AD12 use the IF function to enter Yes if the Departure Delay in Minutes is greater than 40 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)

Blank 1

7.In cell AE12 use the IF function to enter long if the Flight Time in Minutes is greater than 150 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)

Blank 1

8.Use SimpleFiltersto answer the following question:

.

How many records meet the following criteria: Airline Code is AS, DL, F9 and Destination State is Connecticut or Indiana or Kentucky or Missouri or Maryland and Type of Travel is Business Travel or Mileage Tickets.

Record your answer and then clear the filter.

.

9.Create a PIVOT tableto answer the question.

.

How many records meet the following criteria: Origin State is Florida and the Flight is not cancelled.

Blank 1

10.Use Advanced Filtersonly to answer the question.Filter the list in place. Keep theresults or no marks will be rewarded.

.

How many records meet the following criteria: Age is lower than 40and No of Flights per Annum is lower than 40 and Type of Travel is Personal TravelORFlight Cancelled is Yesand Airline Status is Gold and Gender is Female.

Blank 1

https://docs.google.com/spreadsheets/d/1XQ9h8Vhf8ygFjkZAjr9fkF-k5fn_TQ7a/edit?usp=drive_link&ouid=106020471773606203483&rtpof=true&sd=true