Formula structure and cell references 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

= [1](A1, B1)

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

ATOTAL

BSUM

CPLUS

DADD

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'ADD' or 'PLUS' which are not valid functions.

Forgetting to use a function and just typing 'A1 + B1' without '='.

The SUM function adds numbers in Google Sheets. ADD, PLUS, and TOTAL are not valid functions.

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 '+' instead of '*' for multiplication.

Using '/' which divides instead of multiplies.

The asterisk * is used for multiplication in formulas.

3fill in blank

hard

Fix the error in the formula to calculate the average of cells A1 to A5.

Google Sheets

= [1](A1:A5)

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

ASUM

BTOTAL

CCOUNT

DAVERAGE

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of AVERAGE.

Using TOTAL which is not a valid function.

The AVERAGE function calculates the mean of the numbers in the range. SUM adds them, COUNT counts cells, and TOTAL is not a valid function.

4fill in blank

hard

Fill both blanks to create a formula that subtracts the value in cell B2 from cell A2 and then divides the result by 5.

Google Sheets

= (A2 [1] B2) [2] 5

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

A-

B+

C/

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' instead of '-' for subtraction.

Using '*' instead of '/' for division.

First subtract B2 from A2 using -, then divide the result by 5 using /.

5fill in blank

hard

Fill the blanks to create a formula that calculates the sum of cells A1 to A3 only if the value in B1 is greater than 10.

Google Sheets

=IF(B1 [1] 10, SUM(A1:A3), 0)

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

A>

B:

C<

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' in the condition.

Using ',' instead of ':' for the range.

The formula uses IF to check if B1 is greater than 10 (>). If true, it sums the range A1 to A3 (using :), otherwise returns 0.