Use the following Excel screenshot and information to answer the following TWO questions . Questions are INDEPENDENT . The following table lists some...
Could you please help me figure out the values for each space?
Use the following Excel screenshot and information to answer the following TWO questions .Questions are INDEPENDENT .The following table lists some of the major airports in Canada and the United States . Column Acontains the airport name , followed by the two-letter abbreviation of the province / state where*the airport is located , and the three- letter IATA code . For example , Vancouver Airport is located in*the province of &C , and it has YVR as its three- letter IATA code .2AirportProvince / State*ICAO CodeAbbreviation Province / State*3Vancouver BC YVRBritish ColumbiaCYVRABAlbertaCalgary AB YYCAlbertaCYYCBCBritish Columbia5Newark NJ EWRNew JerseyKEWVRONOntario*6Seattle Tacoma WA SEA WashingtonKSEAWAWashingtonToronto Pearson ON YYZ OntarioCYYZNJNew Jersey8| Los Angeles CA LAXCaliforniaKLAXMIDMaryland9OROregon10CACaliforniaTiana was asked to use the look up table EZ : F10 to extract the full name of the province / statewhere each airport is located . For example , if the two - letter abbreviation is AE ( refer to row 4 ) .then Alberta should be displayed . She typed up a formula in cell B.3 , and subsequently draggeddown the formula to complete the rest of the column without manually changing it .Complete the following formula in cell B.3 .CONSTRAINTS FOR THIS QUESTION :". The ONLY thing that can go in each blank is either a FUNCTION name ( such as , but not limitedto , VLOOKUP , COUNTIES , etc. ) or a NUMBER .. You may NOT enter any cell references or any value other than a function name or a number .( A3 ,1 . 21 , S E $ 3 : 5 8$10 ,* FALSE ]
Show more
