你还在为考试焦头烂额?找我们就对了!

我们知道现在是考试月,你正在为了考试复习到焦头烂额。为了让更多留学生在备考与学习季更轻松,我们决定将Gold会员限时免费开放至2025年12月31日!原价£29.99每月,如今登录即享!无门槛领取。

助你高效冲刺备考!

题目
题目

COMM_V 205 101 102 103 2025W1 In-class Exercise (ICE) 5

多项填空题

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], ))  

题目图片
查看解析

查看解析

标准答案
Please login to view
思路分析
The task presents a complex Excel formula with multiple blanks that must be filled to reference a lookup table and extract the correct province/state names from two-letter abbreviations. First, consider the overall structure of the intended formula. The goal is to take a two-letter abbreviation found in column A, look up the full province/state name from the lookup range E3:F10, and then return that full name into column B. The approach commonly used for such a task involves a combination of INDEX and MATCH (and possibly MID or RIGHT if the A3 cell contains more than just the abbreviation). Now let's analyze each provided fill-in carefully. 1) The first blank is to specify the function that will fetch a value from the lookup table using row and column indices. The corr......Login to view full explanation

登录即可查看完整答案

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

更多留学生实用工具

为了让更多留学生在备考与学习季更轻松,我们决定将Gold 会员限时免费开放至2025年12月31日!