DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What does the VLOOKUP function do?
|
|
Looks up text that contain ‘v’
|
|
|
Checks whether text is the same in one cell as in the next
|
|
|
Finds related records
|
|
|
All of above
|
Explanation:
Detailed explanation-1: -VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so-called ‘table array’), in order to return a value from a different column in the same row.
Detailed explanation-2: -You can use the Count function to determine if a record has any related records.
Detailed explanation-3: -Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. For example, let’s say you know the part number for an auto part, but you don’t know the price.
There is 1 question to complete.