Which one of the following statements correctly distinguishes the HLOOKUP and…
RSSB Computer Instructor 2026
Which one of the following statements correctly distinguishes the HLOOKUP and VLOOKUP functions in MS Excel with respect to the direction in which they search for the lookup value ?
- A.
HLOOKUP searches vertically down a column, whereas VLOOKUP searches horizontally across a row.
- B.
HLOOKUP and VLOOKUP perform identical operations and differ only in their names.
- C.
HLOOKUP is used for retrieving data for horizontal charts, whereas VLOOKUP is used for retrieving data for vertical charts.
- D.
HLOOKUP searches across the first row of a table, whereas VLOOKUP searches down the first column of a table.
- E.
Question not attempted
Attempted by 134 students.
Sign up free to check your answer
Sign up freeLoading lesson…

