Google Sheets Quiz 30/09/2024
Authored by Olzhas Toktassyn
Information Technology (IT)
University
Used 3+ 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
1 min • 5 pts
What does the COUNTIF function do in Google Sheets?
Counts cells in a range that meet a specific condition
Counts all the cells in a range
Adds values in a range
Averages values in a range
2.
MULTIPLE CHOICE QUESTION
1 min • 5 pts
Which function would you use to find the average of numbers in a range?
COUNT
AVERAGE
SUM
MAX
3.
MULTIPLE CHOICE QUESTION
1 min • 5 pts
Which function counts only the cells that are not empty?
COUNTIF
COUNTA
COUNTBLANK
AND
4.
MULTIPLE CHOICE QUESTION
1 min • 5 pts
Which function would you use to count the blank cells in a range?
COUNT
COUNTBLANK
COUNTA
AVERAGE
5.
MULTIPLE CHOICE QUESTION
1 min • 5 pts
What does the AND function return?
TRUE if all conditions are met
A sum of all values
The first condition that is true
The maximum value in a range
6.
MULTIPLE CHOICE QUESTION
1 min • 5 pts
What is the difference between AVERAGEIF and AVERAGE?
AVERAGEIF averages only cells that meet a condition
They both work the same
AVERAGE works with conditions
AVERAGEIF counts values instead of averaging them
7.
MULTIPLE CHOICE QUESTION
1 min • 5 pts
Which function counts the number of cells in a range based on a condition?
COUNT
COUNTIF
COUNTA
COUNTBLANK
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 Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
