Arithmetic operators in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to add the 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 * or / instead of +

Forgetting to include the operator

The plus sign (+) adds two numbers in Google Sheets formulas.

2fill in blank

medium

Complete the formula to subtract the value in B2 from A2.

Google Sheets

=A2 [1] B2

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

A/

B+

C*

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using + instead of -

Swapping the order of cells

The minus sign (-) subtracts the second number from the first in Google Sheets formulas.

3fill in blank

hard

Fix the error in the formula to multiply values in C3 and D3.

Google Sheets

=C3 [1] D3

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

A/

B*

C+

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using + or - instead of *

Using / which divides instead of multiplies

The asterisk (*) is used to multiply numbers in Google Sheets formulas.

4fill in blank

hard

Fill both blanks to divide the value in E4 by F4 and then add 10.

Google Sheets

=E4 [1] F4 [2] 10

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

A/

B+

C-

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the order of operators

Using - or * instead of + for addition

First, divide E4 by F4 using the slash (/), then add 10 using the plus (+) operator.

5fill in blank

hard

Fill all three blanks to calculate the square of G5, subtract 5, then multiply by 2.

Google Sheets

=((G5 [1] 2) [2] 5) [3] 2

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

A^

B-

C*

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Using * instead of ^ for power

Mixing up subtraction and addition

Forgetting parentheses

Use the caret (^) to square G5, subtract 5 with (-), then multiply by 2 with (*).