
Excel Functions Quiz
Quiz
•
Computers
•
10th Grade
•
Practice Problem
•
Hard
W. Gamal
Used 3+ times
FREE Resource
Enhance your content in a minute
9 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the FILTER function do?
Filters data based on conditions
Counts numeric values
Calculates sums
Averages data
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which cells are counted by COUNTA?
Numeric cells
Blank cells
Non-empty cells
Cells matching criteria
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the syntax of the COUNTIF function?
=COUNTIF(range, criteria)
=COUNTIF(criteria, range)
=FILTER(range, criteria)
=COUNTA(range)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does nesting FILTER in COUNT accomplish?
Finds average values
Counts only filtered results
Counts blank cells
Sorts the dataset
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the benefit of absolute references?
They make formulas adaptable for multiple uses.
They avoid formula repetition errors.
They allow consistent range selection.
All of the above.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does =COUNT(range) do?
Counts numeric cells only
Counts all non-empty cells
Filters the range
Returns a "Yes" count
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Why use COUNTA instead of COUNT?
To count only blank cells
To count text and numeric values
To simplify filtering
To sort a dataset
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
Microsoft Office Word
Quiz
•
4th Grade - University
7 questions
OCR Computer Science 2.3 Testing
Quiz
•
8th - 11th Grade
12 questions
IMedia Recap
Quiz
•
9th - 11th Grade
10 questions
aplikasi pengolah angka
Quiz
•
10th Grade
10 questions
python quiz
Quiz
•
6th Grade - Professio...
10 questions
Toon Boom Tools 1
Quiz
•
10th Grade
10 questions
Java: repetition control structure for & while
Quiz
•
10th - 12th Grade
13 questions
Structured information_E
Quiz
•
6th - 12th Grade
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
