
Excel Functions Quiz
Quiz
•
Professional Development
•
University
•
Practice Problem
•
Hard
Kavitha GRGSMS
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the VLOOKUP function do?
Counts the number of cells that meet a condition
Creates a chart based on selected data
Searches for a value in a table and returns a corresponding value
Calculates the sum of a range of cells
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the syntax for the VLOOKUP function?
=VLOOKUP(lookup_value, col_index_num, table_array, [range_lookup])
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(table_array, lookup_value, col_index_num, [range_lookup])
=VLOOKUP(col_index_num, lookup_value, table_array, [range_lookup])
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to search for a value horizontally?
XLOOKUP
VLOOKUP
LOOKUP
HLOOKUP
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the XLOOKUP function?
To search a range and return the first match found
To create a pie chart
To sum a range of values
To count the number of cells
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is NOT a common type of chart in Excel?
Matrix Chart
Pie Chart
Bubble Chart
Histogram
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the IF function do in Excel?
Sums a range of values
Creates a chart based on data
Counts the number of cells in a range
Performs logical tests and returns values based on conditions
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the syntax for the COUNTIF function?
=COUNTIF(value1, value2)
=COUNTIF(range, value)
=COUNTIF(range, criteria)
=COUNTIF(criteria, range)
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
12 questions
KERANGKA BERPIKIR
Quiz
•
University
10 questions
Nature of Communication
Quiz
•
University
15 questions
MB_Chapter4_ The Demand for Money
Quiz
•
University
10 questions
Building Services 2
Quiz
•
University
15 questions
Emerging Trends in Technology
Quiz
•
University
11 questions
Economics Production Function Quiz
Quiz
•
University
10 questions
FINANCIAL EDUCATION
Quiz
•
University
10 questions
Career Choices
Quiz
•
9th Grade - University
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 Professional Development
7 questions
How James Brown Invented Funk
Interactive video
•
10th Grade - University
5 questions
Helping Build the Internet: Valerie Thomas | Great Minds
Interactive video
•
11th Grade - University
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
23 questions
Subject Verb Agreement
Quiz
•
9th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
19 questions
Review2-TEACHER
Quiz
•
University
15 questions
Pre2_STUDENT
Quiz
•
University
20 questions
Ch. 7 Quadrilateral Quiz Review
Quiz
•
KG - University
