
Mastering Google Sheets Formulas
Authored by Roberto Cistia
Computers
9th Grade
Used 5+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
37 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the function used to add up a range of cells in Google Sheets?
AVERAGE
SUM
COUNT
MAX
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to count the number of cells that are not empty in a range?
COUNT
COUNTA
COUNTIF
COUNTBLANK
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you apply conditional formatting to highlight cells greater than 100?
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to find the average of cells that meet a specific condition?
AVERAGE
AVERAGEIF
SUMIF
COUNTIF
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct syntax for the SUMIF function?
SUMIF(range, criteria, [sum_range])
SUMIF(criteria, range, [sum_range])
SUMIF([sum_range], range, criteria)
SUMIF(range, [sum_range], criteria)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to return the smallest number in a range that meets a single condition?
MIN
MINIF
MINIFS
MINIMUM
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How would you format a cell to display currency in Google Sheets?
Format > Number > Currency
Format > Number > Percentage
Format > Number > Date
Format > Number > Plain Text
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
40 questions
PowerPoint 1
Quiz
•
6th - 12th Grade
40 questions
SOAL SUMATIF 2
Quiz
•
9th - 12th Grade
32 questions
Excel Review
Quiz
•
9th - 12th Grade
40 questions
GCSE (9–1) CS 1.3 Networks, connections & protocols
Quiz
•
9th - 11th Grade
34 questions
GCSE Unit 2.3 - Producing Robust Programs
Quiz
•
9th Grade
40 questions
Linux2 - Lesson 6 (exam training)
Quiz
•
1st - 10th Grade
35 questions
PLTW CSE Unit 1.3 Review
Quiz
•
9th - 12th Grade
40 questions
Latihan ganjil
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