USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -A logical value that specifies whether you want VLOOKUP to find an approximate or an exact match: Approximate match-1/TRUE assumes the first column in the table is sorted either numerically or alphabetically, and will then search for the closest value. This is the default method if you don’t specify one.
Detailed explanation-2: -If VLOOKUP doesn’t find an exact match, it will continue scanning until it finds a value greater than the lookup value, then it will “step back", and return the grade in the previous row. In other words, VLOOKUP will match the last value that is less than or equal to the lookup value.
Detailed explanation-3: -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-4: -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-5: -We can two criteria in Vlookup functions, which are TRUE and FALSE. FALSE gives us the exact match whereas TRUE gives us the approximate match for the value if not in lookup range.