DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
In reverse-alphabetical order
|
|
|
in numerically ascending order
|
|
|
in numerically descending order
|
|
|
in alphabetical order
|
Detailed explanation-1: -To use the vlookup function to get an approximate match value, your first column in the table must be sorted in ascending order, otherwise it will return a wrong result.
Detailed explanation-2: -If set to TRUE or “1” (which is the default) VLOOKUP will allow a non-exact match. If set to “0” or FALSE, VLOOKUP will require an exact match. In this case, we definitely want to allow a non-exact match because the exact sales amounts will not appear in the lookup table, so I’ll use TRUE.
Detailed explanation-3: -In the Range lookup, you can optionally specify TRUE if you want an approximate match or FALSE if you want an exact match of the return value. If you leave this blank, the default value will always be TRUE, or approximate match.
Detailed explanation-4: -In most situations, where the lookup value is a unique known identifier, exact match is used to return the exact corresponding information in the same row. In some occasions, where the lookup value is not unknown, approximate match is used to find the closest match, given the criteria.
Detailed explanation-5: -The VLOOKUP function consists of three required arguments, in the following order: lookup value, table array, and column index number. The lookup value is the value for which you want to find matching data and must appear in the first column of the lookup table; it can be a value, a text string, or a cell reference.