What does the VLOOKUP function do in Excel?

Excel Functions Quiz

Quiz
•
Other
•
Professional Development
•
Easy
Mahipal Jadeja
Used 1+ times
FREE Resource
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Finds text within text
Searches for a value by row and returns corresponding data
Adds values across a column
Filters the data
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function should you use to add all salaries of employees in the 'Sales' department?
COUNTIF
SUMIF
HLOOKUP
INDEX
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will the formula =IF(A1>10000, 'Eligible', 'Not Eligible') return when A1 = 9500?
TRUE
Not Eligible
Eligible
FALSE
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following functions checks whether a cell contains a number?
ISNA
ISBLANK
ISNUMBER
ISTEXT
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct syntax for the SUMIFS function?
SUMIFS(criteria_range, sum_range)
SUMIFS(sum_range, criteria_range, criteria)
SUMIFS(criteria, range)
SUMIFS(sum_range)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does HLOOKUP search through?
First column
First row
First cell
Last column
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is useful for handling division-by-zero errors in Excel?
IF
INDEX
IFERROR
COUNTIFS
Create a free account and access millions of resources
Similar Resources on Quizizz
10 questions
Critique and Development of Classroom Instructional Instruments

Quiz
•
Professional Development
10 questions
Digital Accountant

Quiz
•
Professional Development
20 questions
Microsoft Excel

Quiz
•
KG - Professional Dev...
10 questions
Knowledge Check - Smart Forms/eSignature Activity

Quiz
•
Professional Development
15 questions
Data Analytics Quiz

Quiz
•
Professional Development
20 questions
Assessment Vocabulary

Quiz
•
Professional Development
15 questions
E4F Unit 5 - Job Roles

Quiz
•
Professional Development
20 questions
AGRICULTURE AND FINANCIAL INCLUSION

Quiz
•
Professional Development
Popular Resources on Quizizz
15 questions
Multiplication Facts

Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
15 questions
June Review Quiz

Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade