
Excel Functions Quiz
Quiz
•
Computers
•
10th Grade
•
Practice Problem
•
Easy
Ohann Dyk
Used 2+ times
FREE Resource
Enhance your content in a minute
7 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function would you use to find the average of a range?
=min()
=count()
=average()
=sum()
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function returns the current date?
=now()
=mode()
=today()
=randbetween()
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the function =countif() do?
Counts the total number of cells
Counts the number of blank cells
Counts the number of cells in a range given a certain criteria
Counts the number of cells that are not empty
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to get the largest value in a range?
=countblank()
=small()
=median()
=max()
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the function =randbetween() return?
A random date
A random number between the values entered
The current time
The smallest value in a range
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to count the number of non-empty cells in a range?
=count()
=countif()
=countblank()
=sum()
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function counts the amount of empty cells in a range?
=count()
=counta()
=countblank()
=countempty()
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
11 questions
Microsoft Word
Quiz
•
2nd - 10th Grade
10 questions
TIN HỌC 10 - BÀI 20
Quiz
•
10th Grade
10 questions
Python with DataScience
Quiz
•
7th Grade - University
11 questions
Computer Professionals
Quiz
•
7th - 12th Grade
12 questions
Programming - Output
Quiz
•
KG - 12th Grade
10 questions
UH EXCEL TIK
Quiz
•
10th Grade
10 questions
Advanced SQL
Quiz
•
KG - University
12 questions
Excel VBA
Quiz
•
10th 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
