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

Question

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

Quizplus · Accepted Answer

HLOOKUP is used for horizontal lookup, which searches for a value in the top row of a table and returns a corresponding value in the same column of a specified row. This is useful when the table is structured horizontally. VLOOKUP, on the other hand, is used for vertical lookup and is appropriate when the table is structured vertically. MLOOKUP and ZLOOKUP are not actual functions in Excel.

The ____ Function Is Used When the Table Direction Is