How to Use Formulas in Google Sheets

How to Use Formulas in Google Sheets

Assessment

Interactive Video

Social Studies, Mathematics

11th Grade - University

Hard

Created by

Quizizz Content

FREE Resource

Tyler from Tarver Academy introduces basic formulas in Google Docs, focusing on addition and average functions. He demonstrates how to use the sum function, both by selecting cells and using the drag method. Tyler also explains how to apply formulas vertically and horizontally, and how to use the function bar with the equal sign to perform calculations. The video emphasizes making tasks easier with Google Docs' built-in features.

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