What row does a VLOOKUP utilize? A. The one specified by the search term B. The
ID: 3684514 • Letter: W
Question
What row does a VLOOKUP utilize?
A. The one specified by the search term
B. The one above the table specified
C. The one specified in the third argument
D. The first one Q7
What column does a VLOOKUP search?
A. The one specified by the search term
B. The one left of the table specified
C. The one specified in the third argument
D. The first one
Q8 What column does an HLOOKUP utilize?
A. The one specified by the search term
B. The one left of the table specified
C. The one specified in the third argument
D. The first one
What row does an HLOOKUP return?
A. The one specified by the search term
B. The one above the table specified
C. The one specified in the third argument
D. The first one
What determines if a VLOOKUP or HLOOKUP should be used?
A. The question that is asked and the structure of the table
B. VLOOKUP should always be used; HLOOKUP is just there to catch a mistake
C. What your boss wants done
D. The reading conventions you learn based on your native language
Explanation / Answer
What row does a VLOOKUP utilize?
A. The one specified by the search term
What column does a VLOOKUP search?
B. The one left of the table specified
What column does an HLOOKUP utilize?
B. The one left of the table specified
What row does an HLOOKUP return?
A. The one specified by the search term
What determines if a VLOOKUP or HLOOKUP should be used?
B. VLOOKUP should always be used; HLOOKUP is just there to catch a mistake
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.