$1.(0-9$ pts$)$ Write an Excel function in cell Analysis!B$3,$ which can be copied across the row and down the column into range B$3$:D$6,$ to determine if this airline has any flights to this destination. $($Display $$Available$$ or $$Not Available$).($Hint: Use the IF$()$ function here where the logical testreferences a cell in another worksheet and always check for if a $ is needed for the numbers in any cells used since you are copying this function down AND also check for if a $ is needed for the letters in any cells used since you are also copying this function across.$).=$IF$($flights are available for this airline to destination cell reference in Flights worksheet, display Available, display Not Available$)=$IF$(,$Available$,$Not Available$)2.(0-9$ pts$)$ Write an Excel function in cell Analysis!E$3,$ which can be copied down the column, to determine if this airline has flights to all $3$ locations. $($Display $$All $$or $$Not All$).($Hint: Use the IF$()$ function here where the logical test is the AND$()$ function with three arguments and always check for if a $ is needed for the numbers in any cells used since you are copying this function down.$).=$IF$($flights available to all $3$ destinations, display All, display Not All$)=$IF$($AND$(=$Available$,=$Available$,=$Available$),$All$,$Not All$)3.(0-9$ pts$)$ Write an Excel function in cell Analysis!F$3,$ which can be copied down the column, to determine if this airline has flights to any of the $3$ locations. $($Display $$At least One$$ or $$None$).($Hint: Use the IF$()$ function here where the logical test is the OR$()$ function with three arguments and always check for if a $ is needed for the numbers in any cells used since you are copying this function down.$).=$IF$($flights available to any of the $3$ destinations, display At Least One, display None$)=$IF$($OR$(=$Available$,=$Available$,=$Available$),$At Least One$,$None $)4.(0-9$ pts$)$ Write an Excel function in cell Analysis!G$3,$ which can be copied down the column, to determine if this airline has flights to at least two of the locations. $($Display $$At Least Two$$ or $$Less than Two$).($Hint: Use the IF$()$ function here where the logical test is the COUNTIF$()$ function using a range and checking for $$Available$.$ Then the result of this COUNTIF$()$ function will be compared to $>1$ to evaluate to either a TRUE or FALSE as the logical test. Remember to always check for if a $ is needed for the numbers in any cells used since you are copying this function down.$).=$IF$($COUNTIF$($criteria range of flights available from this worksheet for airline, criteria of Available$)$ is greater than $1,$ display At Least Two, display Less Than Two$)=$IF$($COUNTIF$(,$Available$)>1,$At Least Two$,$Less Than Two$)5.(0-8$ pts$)$ Your employee Martha is considering using Frequent Flyer miles to plan a vacation. She only goes to Chicago on business so the airline must fly to Chicago. She wants the airline to also fly to either New York or Boston so she can plan a vacation. Write an Excel function in cell Analysis!H$3,$ which can be copied down, to determine if this airline meets Martha$$s criteria. $($Display $$Will Fly$$ or $$Will Not Fly$).($Hint: Use the IF$()$ function here where the logical test is the AND$()$ function with two arguments, one of which is an embedded OR$()$ function with two arguments. Remember to always check for if a $ is needed for the numbers in any cells used since you are copying this function down.$).=$IF$($AND$($Airline fly to Chicago?, OR$($Airline fly to New York?, Airline fly to Boston?$)),$ display Will Fly, display Will Not Fly$)=$IF$($AND$(,$ OR$(,)),$Will Fly$,$Will Not Fly$$