DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Table
|
|
|
Data
|
|
|
Chart
|
|
|
Formula
|
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.