DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Vlookup is determined based on column numbers while Hlookup is determined based on row numbers
|
|
|
Vlookup is determined based on row numbers while Hlookup is determined based on column numbers
|
|
|
Vlookup and Hlookup are both determined based on column no
|
|
|
Vlookup and Hlookup are both determined by line no
|
|
|
vlookup and hlookup are not excel functions
|
Detailed explanation-1: -Vlookup True is used when we don’t get an exact match but with the help of TRUE, we can get an approximate match or near value to the value which we are looking for. We can two criteria in Vlookup functions, which are TRUE and FALSE.
Detailed explanation-2: -The VLOOKUP(value, range, result column, exact match) is correct.
Detailed explanation-3: -VLOOKUP allows you to search a data range that is set up vertically. HLOOKUP is the exact same function, but looks up data that has been formatted by rows instead of columns. LOOKUP and related functions are commonly used for business analytics in Excel as a way of slicing and dicing data for analysis.
Detailed explanation-4: -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.