Quiz – Google Sheets Functions & Charts
Authored by Rw8 Sodvadiya
Information Technology (IT)
University
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
28 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula checks if a value is greater than 100 and returns “Yes” if true?
=IF(A1100, "Yes", "No")
=IF(A1=100, "Yes", "No")
=IF(A1<>100, "Yes", "No")
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of nesting IF formulas?
To format cells
To combine multiple conditions in one formula
To create charts
To import data
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula returns “Good” if score is above 80 and “Average” if above 50?
=IF(A1>80, "Good", IF(A1>50, "Average", "Poor"))
=IF(A150, "Poor", "Good")
=IF(A1=80, "Good", "Average")
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the AND function do in Google Sheets?
Checks if at least one condition is true
Checks if all conditions are true
Creates text format
Filters dates only
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula checks if a cell is greater than 100 OR less than 50?
=OR(A1>100, A1100, A1100, A1<50)
=OR(A1=100, A1=50)
6.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
Which formula counts cells that meet multiple criteria?
AVERAGEIFS(A1:A10, B1:B10, "East")
COUNTIFS(A1:A10, ">10", B1:B10, "1000")
COUNTIF(A1:A10, ">10")
COUNT(A1:A10)
=SUM(A2:A10)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the LEFT function do?
Extracts characters from the end of a text
Extracts characters from the beginning of a text
Counts text characters
Sums numeric values
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?
