Question

Values in a "closest match" VLOOKUP table must be sorted in descending order so that the VLOOKUP function can make accurate comparisons.

A) True
B) False

Answer 1

The statement in the question is False. Values in a VLOOKUP table must be sorted in ascending order, not descending order.

Step-by-step explanation:

The statement in the question is False. In a VLOOKUP table, the values must be sorted in ascending order, not descending order. This allows the VLOOKUP function to accurately compare the lookup value with the values in the table. If the values were sorted in descending order, the VLOOKUP function would not work correctly.

For example, if you have a VLOOKUP table with student names and their corresponding test scores in ascending order of scores, you can use the VLOOKUP function to find the test score of a specific student. However, if the scores were sorted in descending order, the VLOOKUP function would give incorrect results.