If you wanted to insert a new column I, which would move the table of carrier codes to start in cell Q1, which of the following formulae could you use to insert the full carrier name for each flight then copy it down for all flights on the table? Choose all that apply.

Question

BlackTom AI · Accepted Answer

We’re evaluating which VLOOKUP formulas would correctly insert the full carrier name for each flight and then copy the formula down the table, given the goal to place the table of carrier codes starting at column Q and row 1 (cell Q1) and pull the name from the second column of the lookup range.
Option 1: =VLOOKUP(H3,Q2:R18,2)
This uses a lookup value of H3, but the table array Q2:R18 has no absolute references. When you copy this formula down a column, Excel will adjust both the lookup value and the table range relative to the new row. That means the table range would shift (e.g., Q3:R19 on the next row), which typically breaks the intended fixed lookup table and yields incorrect results for rows beyond the first. Therefore this option is unreliable for filling down a whole column.

Option 2: =VLOOKUP(H3,Q$2:R$18,2)
Here, the lookup value is still H3, which will adjust to H4, H5, etc., as you copy down, which correctly refers to the carrier code in the current row. The table array uses absolute row references ($2 and $18), so the lookup table stays fixed in Q2:R18 while you copy the formula down. This is a correct approach to populate the full carrier name down the table.

Option 3: =VLOOKUP($H$3,$Q$2:$R$18,2)
The lookup value is $H$3, which is an absolute reference; copying this formula down will not move to H4, H5, etc. You would repeatedly look up the same value in H3 for every row, which is not correct behavior for filling down a column where each row should use its own code from column H. The table array is properly fixed, but the lookup value is not adaptable across rows, so this option misbehaves.

Option 4: =VLOOKUP(H3,$Q$2:$R$18,2)
This formula uses H3 as the lookup value (which will adjust to H4, H5, etc., as you copy down). The table array is fixed to Q2:R18, so the range used for the lookup remains constant across rows. This combination correctly references the current row’s code and preserves the lookup table, making it a proper choice for filling down.

In summary, options that maintain a fixed lookup table while allowing the lookup value to change as you copy down are appropriate for this task. If you’re going to fill the column down, you typically want to keep the table range anchored with dollar signs and let the lookup value reference move with each row, which aligns with options 2 and 4. The first option fails because the table range moves when copying down, and the third option fails because the lookup value is anchored and does not move with the rows.

BUSI_V 335 972 2025SS MT2 Practice Exam - Airports

If you wanted to insert a new column I, which would move the table of carrier codes to start in cell Q1, which of the following formulae could you use to insert the full carrier name for each flight then copy it down for all flights on the table? Choose all that apply.

查看解析

登录即可查看完整答案

类似问题

T/F To answer the above question, one can also use the following formula. =VLOOKUP(A26,A2:C23,2,FALSE)&" "&"won the cup in"&" "&A26&"." Note: The " " instances represent strings consisting of a single blank space.

What would you need to do to use VLOOKUP to place the month names in column C, using the table in columns K-L?

The first column of a VLookup table must:Choose carefully! You will only receive a mark if you choose all of the correct answers and no incorrect answers.

To return (display) excellent from the VLookup table shown, the col_index_num in the IF function arguments should be

更多留学生实用工具

考试浏览器助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单