What does Vlookup stand for in Excel?
Vlookup Formula in Excel

Quiz
•
Computers
•
Professional Development
•
Medium
Sharad Choudhari
Used 92+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Variable Lookup
Vertical Lookup
Vertical Loop
Virtual Lookup
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the syntax of the Vlookup formula?
=SUMIF(range, criteria, [sum_range])
=INDEX(lookup_array, MATCH(lookup_value, lookup_array, 0))
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of using Vlookup in Excel?
To search for a value in a table and return a corresponding value from another column.
To insert a new row in the spreadsheet
To change the font style of a cell
To calculate the sum of a range of cells
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What are the four arguments of the Vlookup function?
lookup_value, table_array, row_index_num, and range_lookup
search_value, data_array, col_index_num, and exact_match
value_to_find, array_to_search, index_num, and approximate_match
lookup_value, table_array, col_index_num, and range_lookup
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How does Vlookup search for a value in a table?
It searches for a value in the rightmost column of a table.
It searches for a value in the middle column of a table.
It searches for a value in the leftmost column of a table.
It searches for a value in all columns of a table.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What happens if the lookup value is not found in the table?
Lookup value becomes zero
#N/A or #VALUE!
Table explodes
Error 404
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Can Vlookup be used to search for values in multiple columns?
No
Only if the columns are adjacent
Yes, but only in specific versions of Excel
Yes, always
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
Java SE: Programming I

Quiz
•
Professional Development
10 questions
Basic Programming Kotlin

Quiz
•
Professional Development
10 questions
Materi Excell

Quiz
•
Professional Development
10 questions
Advanced Excel

Quiz
•
Professional Development
15 questions
Linked List

Quiz
•
Professional Development
13 questions
Strings and Arrays

Quiz
•
Professional Development
15 questions
Searching and Sorting

Quiz
•
University - Professi...
5 questions
M11 Mulesoft DataWeave

Quiz
•
Professional Development
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade