AVERAGE function in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

Excel

=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 (:)

Separating cells with a semicolon (;) or comma (,)

The correct way to specify a range in Excel is with a colon (:). So A1:A5 means all cells from A1 through A5.

2fill in blank

medium

Complete the formula to calculate the average of cells B2, B3, and B4.

Excel

=AVERAGE([1])

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

AB2-B4

BB2:B4

CB2,B3,B4

DB2;B3;B4

Attempts:

3 left

💡 Hint

Common Mistakes

Using a colon when listing individual cells

Using semicolons instead of commas

When listing individual cells, separate them with commas inside the AVERAGE function, like B2,B3,B4.

3fill in blank

hard

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

Excel

=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 (:)

Using a semicolon (;) or comma (,) instead of a colon

The correct range separator in Excel formulas is a colon (:), so C1:C3 selects cells C1 through C3.

4fill in blank

hard

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

Excel

=AVERAGE([1])

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

AD1-D4

BD1:D4

CD1,D4

DD1;D4

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash (-) or semicolon (;) instead of a colon (:)

Separating cells with commas when a range is needed

The correct way to specify the range is D1:D4. Empty cells are ignored automatically by AVERAGE.

5fill in blank

hard

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

Excel

=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 other separators instead of commas

To average specific cells, list each cell separated by commas inside the AVERAGE function.