Why formulas automate calculations in Google Sheets - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to add values in cells A1 and B1.

Google Sheets

=A1 [1] B1

Drag options to blanks, or click blank then click option'

A+

B/

C*

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using minus (-) instead of plus (+)

Using multiplication (*) or division (/) by mistake

The plus sign (+) adds the values in A1 and B1.

2fill in blank

medium

Complete the formula to multiply the value in cell C2 by 10.

Google Sheets

=C2 [1] 10

Drag options to blanks, or click blank then click option'

A-

B*

C+

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus (+) instead of multiply (*)

Using division (/) or minus (-) by mistake

The asterisk (*) multiplies the value in C2 by 10.

3fill in blank

hard

Fix the error in the formula to subtract B3 from A3.

Google Sheets

=A3 [1] B3

Drag options to blanks, or click blank then click option'

A+

B*

C-

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus (+) instead of minus (-)

Using multiplication (*) or division (/) by mistake

The minus sign (-) subtracts B3 from A3.

4fill in blank

hard

Fill both blanks to create a formula that divides D4 by 2 and adds 5.

Google Sheets

=D4 [1] 2 [2] 5

Drag options to blanks, or click blank then click option'

A/

B+

C-

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using multiplication (*) instead of division (/)

Using subtraction (-) instead of addition (+)

First, divide D4 by 2 using '/', then add 5 using '+'.

5fill in blank

hard

Fill all three blanks to create a formula that multiplies E5 by 3, subtracts 4, and then divides by 2.

Google Sheets

=((E5 [1] 3) [2] 4) [3] 2

Drag options to blanks, or click blank then click option'

A*

B-

C/

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up the order of operations

Using addition (+) instead of subtraction (-) or division (/)

Multiply E5 by 3 with '*', subtract 4 with '-', then divide by 2 with '/'.