AVERAGE function in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to calculate the average of numbers in cells A1 to A5.

Google Sheets

=AVERAGE([1])

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

AA1-A5

BA1,A5

CA1;A5

DA1:A5

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' instead of a colon ':' for ranges.

Separating cells with commas or semicolons instead of a colon.

The correct range syntax in Google Sheets uses a colon to specify a continuous range of cells, like A1:A5.

2fill in blank

medium

Complete the formula to calculate the average of numbers in cells B2, B4, and B6.

Google Sheets

=AVERAGE([1])

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

AB2-B6

BB2:B6

CB2,B4,B6

DB2;B4;B6

Attempts:

3 left

💡 Hint

Common Mistakes

Using a colon ':' when cells are not continuous.

Using semicolons or dashes instead of commas.

To average specific cells that are not in a continuous range, list them separated by commas inside the function.

3fill in blank

hard

Fix the error in the formula to correctly calculate the average of cells C1 to C3.

Google Sheets

=AVERAGE(C1[1]C3)

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

A:

B-

C,

D;

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' instead of a colon ':' for ranges.

Using commas or semicolons inside range references.

The colon ':' is required to specify a range from C1 to C3 in Google Sheets.

4fill in blank

hard

Fill both blanks to calculate the average of cells D1 to D4 and ignore empty cells.

Google Sheets

=AVERAGE([1][2])

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

AD1:D4

BD1,D4

CD1;D4

DD1-D4

Attempts:

3 left

💡 Hint

Common Mistakes

Adding extra characters after the range.

Using commas or semicolons instead of a colon.

The correct way to specify the range is D1:D4. The second blank is empty because the range is complete.

5fill in blank

hard

Fill all three blanks to calculate the average of cells E1, E3, and E5.

Google Sheets

=AVERAGE([1],[2],[3])

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

AE1

BE3

CE5

DE2

Attempts:

3 left

💡 Hint

Common Mistakes

Including cells not intended like E2.

Using semicolons or dashes instead of commas.

List each cell separated by commas inside the AVERAGE function to include non-continuous cells.