Vlookup Revision Starter
Authored by Stuart Brown
Computers
9th - 11th Grade
Used 50+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
$B$15 is an Absolute Reference
True
False
2.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
VLOOKUP() searches in the first row of the table.
True
False
3.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
A named range is a relative reference
True
False
4.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
IS this the correct syntax for VLOOKUP(lookup_value, col_index_num, table_array, [range_lookup])?
True
False
5.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
It is best to use a named range for the table reference in VLOOKUP, especially if you want to copy the formula.
True
False
6.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
VLOOKUP() stands for Virtual Lookup
True
False
7.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
The cell reference in a relative reference do not change when you drag a formula
True
False
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
