D1 - The information in the other columns is extracted by...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Part D – Construct LOOKUP Formulas [7 points] Use only the data shown to answer the following questions. All ranges have been named using the labels that appear in the worksheets. The International Air Transport Association (IATA) uses 3 letter codes to identify airports. The table below lists information for a few Canadian airports. In the worksheet below, Flight Codes consist of the Origin and Destination codes of each flight.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: The information in the other columns is extracted by formulae. 1. Create the formula necessary to populate the Airport column for the Origin of each flight. [5] =LOOKUP( LEFT( Flight_Codes, 3), IATA_Code , Airport )) 1 mark for each underlined component 2. Could this have been done using an IF function? BRIEFLY explain.[2] No. It would require more than 7 nested IFs. D1...
View Full Document

Ask a homework question - tutors are online