
Excel Functions Quiz samir
Authored by Raman Shrestha
Other
University
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the VLOOKUP function do?
Looks up values horizontally
Looks up values vertically
Sums values
Filters data
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function searches data horizontally in the first row?
VLOOKUP
INDEX
HLOOKUP
MATCH
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function returns the position of a value in a range?
INDEX
MATCH
CHOOSE
HLOOKUP
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to return the value at a specific row and column?
VLOOKUP
HLOOKUP
INDEX
OFFSET
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct syntax of VLOOKUP?
VLOOKUP(range, value, row_num, FALSE)
VLOOKUP(value, table_array, col_index_num, [range_lookup])
VLOOKUP(col_index_num, value, table_array, TRUE)
VLOOKUP(value, row, column, TRUE)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What happens if VLOOKUP cannot find the value?
Returns 0
Returns blank
Returns #N/A error
Crashes Excel
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function can dynamically return a cell reference by moving rows/columns?
MATCH
INDEX
OFFSET
XLOOKUP
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?
Similar Resources on Wayground
15 questions
Cardi B
Quiz
•
6th Grade - University
15 questions
World Cup Football Quiz
Quiz
•
University - Professi...
15 questions
Intro Psych Exam 1
Quiz
•
University
20 questions
MPMC Quiz 1
Quiz
•
University
20 questions
Vocab - Banking, Investing & The Stock Market
Quiz
•
12th Grade - University
20 questions
Control systems I(Viscosity controller & OMD)
Quiz
•
University
17 questions
UAS Rekayasa Nilai (VE) 2022-1
Quiz
•
University
20 questions
general aptitude
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
Discover more resources for Other
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
20 questions
Endocrine System
Quiz
•
University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
30 questions
W25: PSYCH 250 - Exam 2 Practice
Quiz
•
University
5 questions
Inherited and Acquired Traits of Animals
Interactive video
•
4th Grade - University
20 questions
Implicit vs. Explicit
Quiz
•
6th Grade - University
7 questions
Comparing Fractions
Interactive video
•
1st Grade - University
38 questions
Unit 8 Review - Absolutism & Revolution
Quiz
•
10th Grade - University