The VLOOKUP And HLOOKUP Functions are Used to Read a …

Question

The VLOOKUP And HLOOKUP functions are used to read a …

1. Table
2. Data
3. Chart
4. Formula
5. Cell

Answer

A. Table

Explanation

Well, this isn’t the excel table feature we mean here (although VLOOKUP and HLOOKUP can read it too). It means a data table in general that you can create in a cell range in excel.

Since the closest answer that resembles that is A, this is the correct answer for the question.

VLOOKUP and HLOOKUP themselves are functions you can use to find data you want in a data table/cell range. VLOOKUP will lookup for the data vertically while HLOOKUP will lookup for the data horizontally.

If you want to learn more about these two functions’ usage in excel, you can read our tutorial about them here.

Go back to the Compute Expert's excel quiz page