Excel Spongebob ~vlookup~
- 1.
The lookup_value argument (the value you are searching for) must be in the leftmost column of your list or table.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Excel looks for the lookup_value in the first, or leftmost column of your list or table. If the lookup_value is in some other column, VLOOKUP won’t work.Rate this question:
-
- 2.
What is the table_array argument?
- A.
The lookup table.
- B.
Where you want to search.
- C.
Both of the above.
Correct Answer
C. Both of the above.Explanation
The table_array argument is also called the lookup table. It’s where you want VLOOKUP to search.Rate this question:
-
- 3.
What is the col_index_num argument?
- A.
The column number for your search result column.
- B.
The column heading for your search result column.
Correct Answer
A. The column number for your search result column.Explanation
You count, starting at one with the leftmost column across the list or table to get the number of the column that contains the search result.Rate this question:
-
- 4.
The range_lookup argument is either True, or False. With False, you get:
- A.
An approximate match.
- B.
An exact match.
Correct Answer
B. An exact match.Explanation
False is an exact match, You can also enter “O” for the argument.Rate this question:
-
- 5.
If your range_lookup argument is True, you need to sort the leftmost column in ascending order.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Sort the leftmost column in ascending order (or from a through z), or you may get the wrong results.Rate this question:
-
- 6.
When you use VLOOKUP, you must
- A.
Have a list or table arranged in vertical columns.
- B.
Use a lookup_value in the leftmost column of the lookup table.
- C.
Use the column number, counting from the left, that contains the search result.
- D.
Indicate whether the range_lookup is True (approximate) or False (exact).
- E.
All of the above.
Correct Answer
E. All of the above.Explanation
All of the above are VLOOKUP essentials.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Dec 27, 2013Quiz Edited by
ProProfs Editorial Team -
Dec 27, 2013Quiz Created by
Aishahton
Back to top