DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Retrive the names of workbooks and worksheets
|
|
|
Retrive information according to given criteria
|
|
|
Dynamically change information in different workbooks and worksheets
|
|
|
Retrive information stored in different resources
|
Detailed explanation-1: -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.
Detailed explanation-2: -The VLOOKUP function in Excel is a powerful function used to lookup data in a table organized vertically. It looks down the left column of a range to find a value.
Detailed explanation-3: -The CELL Function[1] is an Excel Information function that will extract information about a cell’s location, contents, or formatting. The CELL function takes two arguments, one that determines the type of information to be extracted and the other that is which cell it will be checking.
Detailed explanation-4: -The Excel LOOKUP function performs an approximate match lookup in a one-column or one-row range, and returns the corresponding value from another one-column or one-row range.