
How to Use Formulas in Google Sheets
Interactive Video
•
Social Studies, Mathematics
•
11th Grade - University
•
Practice Problem
•
Hard
Wayground Content
FREE Resource
Read more
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What symbol is used in Google Docs to access basic functions like sum and average?
A dollar sign ($)
A weird looking e
A hash (#)
A star (*)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you apply the same formula to multiple cells without reselecting each time?
By typing the formula in each cell
By using the copy-paste function
By dragging the small box at the bottom right of the cell
By using the 'Apply to all' button
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to find the average of a set of numbers in Google Docs?
Maximum
Average
Sum
Count
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the first step to create a custom formula in Google Docs?
Start with a plus sign
Start with a division sign
Start with an equal sign
Start with a minus sign
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does Google Docs do to assist you in creating formulas?
It highlights the cells
It locks the cells
It provides suggestions for formulas
It automatically fills in the numbers
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?