The VLOOKUP And HLOOKUP Functions are Used to Read a … - Compute Expert

The VLOOKUP And HLOOKUP Functions are Used to Read a …


Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> Excel Quiz >> 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



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


Excel Calculation

Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division in Excel

Average in Excel



Excel Formula

VLOOKUP Function in Excel

IF Function in Excel

SUM Function in Excel

COUNTIFS Function in Excel

SUMIFS Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text in Excel

Excel Worksheet Definition

Excel Range Definition

Excel Shortcuts



Excel Products & Services Recommendation

Best Laptops for Excel

Best Tablets for Excel

Best Keyboards for Excel

Best Mouse for Excel

Best Monitors for Excel



Excel Consultation

About Us

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2022 Compute Expert