Use the Excel screenshot and details below to answer the next TWO questions. The questions are INDEPENDENT. The table lists major airports in Canada and the United States. Column A contains the airport name, followed by the two-letter province/state abbreviation, and the three-letter IATA code. Example: Vancouver Airport is in BC, and its IATA code is  YVR  (see A3). Tiana must fill The screenshot shows the table after she completed both tasks. For Column B, Tiana was told to use the lookup table E3:F10 to obtain the full name of the province/state from the two-letter abbreviation. Example, if the abbreviation is AB (refer to row 4), then Alberta should be obtained. She entered a formula in B3 (parts redacted), and subsequently dragged down the formula to complete the rest of the column without manually changing it. =XXX($E$3:$E$10,XXX(XXX(XXX(A3,XXX),1,2),$F$3:$F$10,XXX)) Complete the following formula in cell B3. CONSTRAINTS FOR THIS QUESTION: =[Fill in the blank], ($E$3:$E$10,[Fill in the blank], ([Fill in the blank], ([Fill in the blank], (A3,[Fill in the blank], ),1,2),$F$3:$F$10,[Fill in the blank], ))   多项填空题

题目图片

登录即可查看完整答案

我们收录了全球超50000道真实原题与详细解析,现在登录,立即获得答案。

更多留学生实用工具

加入我们,立即解锁 海量真题独家解析,让复习快人一步!