Multiple Choice
All of the following statements are TRUE about the VLOOKUP function EXCEPT:
A) The HLOOKUP function is the more commonly used than the VLOOKUP function.
B) The "V" in VLOOKUP stands for vertical and is used when your comparison values are located in a column or vertically to the left of the data that you want to find.
C) You can use to look up a value and then, using that value as a reference, return data that is associated with that value.
D) VLOOKUP functions are extremely valuable when working with tables where the data is in columns.
Correct Answer:

Verified
Correct Answer:
Verified
Q10: A(n)_ IF increases the logical outcomes that
Q11: The _ function looks for a value
Q12: A(n)_ advantage is the strategic advantage that
Q13: The _ function is a useful tool
Q14: If a value is in the third
Q16: The MATCH and INDEX functions can be
Q17: The _ argument of the COUNTIF function
Q18: The NEVER function allows creation of logical
Q19: The _ function is used when the
Q20: The first argument of the AVERAGEIFS function