Microsoft Excel Tutorial: VLOOKUP Function and Gradebooks
Interactive Video
•
Information Technology (IT), Architecture
•
10th Grade - University
•
Practice Problem
•
Hard
Wayground Content
FREE Resource
Read more
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the primary function of VLOOKUP in Excel?
To search data horizontally and return data from right to left
To search data vertically and return data from left to right
To search data diagonally and return data from top to bottom
To search data randomly and return data in any order
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which component of the VLOOKUP formula specifies the column from which to return the data?
Table area
Search data
Column number
Match type
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In VLOOKUP, what does selecting 'FALSE' for the match type indicate?
A random match
A partial match
An approximate match
An exact match
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When using VLOOKUP with a cell number reference, what is the purpose of pressing F4?
To close the formula
To freeze the cell reference
To open the formula editor
To refresh the data
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How does Excel handle text data in VLOOKUP when using alphabetical search?
It automatically inserts double quotes
It requires manual insertion of double quotes
It ignores text data
It converts text to numbers
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the first step when using VLOOKUP with numeric search data?
Select the last column
Select the first row
Select the entire table
Select the serial number to find
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the context of VLOOKUP, what does an approximate match allow?
Data retrieval from any column
Data retrieval within a range
Random data retrieval
Exact data retrieval
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?
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
Discover more resources for Information Technology (IT)
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
15 questions
Making Inferences
Quiz
•
7th - 12th Grade
18 questions
SAT Prep: Ratios, Proportions, & Percents
Quiz
•
9th - 10th Grade
15 questions
Main Idea and Supporting Details.
Quiz
•
4th - 11th Grade
12 questions
Parallel Lines Cut by a Transversal
Quiz
•
10th Grade
12 questions
Add and Subtract Polynomials
Quiz
•
9th - 12th Grade
7 questions
How James Brown Invented Funk
Interactive video
•
10th Grade - University