
Google Sheets: Working with Functions
Passage
•
Computers
•
8th Grade
•
Practice Problem
•
Easy
Suzanne Dinquel
Used 1+ times
FREE Resource
14 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a function in Google Sheets?
A predefined formula
A random number generator
A text editor
A drawing tool.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fill in the blank: The basic syntax to create a formula with a function is to insert an _________.
argument
equals sign
function name
cell reference
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fill in the blank: A function name is followed by an _________.
equals sign
argument
cell reference
number
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fill in the blank: The function =AVERAGE(B1:B9) would calculate the ________ of the values in the cell range B1:B9.
sum
average
maximum
minimum
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the SUM function do in Google Sheets?
Subtracts values
Adds values
Multiplies values
Divides values
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The MAX function in Google Sheets is used to find: A) The lowest cell value B) The highest cell value C) The average cell value D) The total of all cell values.
The lowest cell value
The highest cell value
The average cell value
The total of all cell values.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In Google Sheets, the MIN function determines: A) The highest cell value B) The lowest cell value C) The average of cell values D) The sum of all cell values.
The highest cell value
The lowest cell value
The average of cell values
The sum of all cell 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 Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
6 questions
The Adventures of Super Sam
Passage
•
6th - 8th Grade
6 questions
Animals in hot-air balloon
Passage
•
8th Grade
14 questions
English Fiele Pre Int4 Sb u2 p20 Au 2.21 / 2.22 (car accident)
Passage
•
9th Grade
6 questions
Đề cương học kỳ 1 Trân Phú _ Passage 2 Đề cương học kỳ 1 Trân Ph
Passage
•
7th Grade
6 questions
Untitled reading quizEnglish Project
Passage
•
7th Grade
11 questions
Madagascar – When TO GO A2
Passage
•
8th Grade
11 questions
Treaty of Versailles Impact and Consequences
Passage
•
8th Grade
9 questions
F RUE 2 Mock 6
Passage
•
KG
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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade