FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The Vlookup and Hlookup functions are used to read an ____
A
Table
B
Data
C
Chart
D
Formula
Explanation: 

Detailed explanation-1: -Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find.

Detailed explanation-2: -Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.

Detailed explanation-3: -The VLOOKUP function is used to find the particular data from a vertical spreadsheet. The HLOOKUP function is used to find the particular data from a horizontal spreadsheet. VLOOKUP is one of the most used functions in excel.

There is 1 question to complete.
Previous
Next