The ____ function is used when the table direction is horizontal.
A) VLOOKUP
B) HLOOKUP
C) MLOOKUP
D) ZLOOKUP

Question

Quizplus · Accepted Answer

HLOOKUP function is used in Excel to search for a value in the top row of a table and then return a corresponding value in the same column from a row that you specify. This function is used for horizontal table orientation, whereas VLOOKUP function is used for vertical table orientation. The other options (MLOOKUP and ZLOOKUP) are not valid Excel functions.

The ____ Function Is Used When the Table Direction Is