
Mastering Google Sheets Formulas
Quiz
•
Computers
•
9th Grade
•
Practice Problem
•
Medium
Roberto Cistia
Used 5+ times
FREE Resource
Enhance your content in a minute
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
Create a free account and access millions of resources
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
35 questions
PLTW CSE Unit 1.3 Review
Quiz
•
9th - 12th Grade
40 questions
Latihan ganjil
Quiz
•
9th Grade - University
35 questions
Ôn tập học kì II - Tin học 9
Quiz
•
9th Grade
40 questions
PRESAF MATPIL XI TKJ
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
32 questions
Google Sheets Basics
Quiz
•
6th - 9th Grade
40 questions
Linux2 - Lesson 6 (exam training)
Quiz
•
1st - 10th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
