SUM function in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to add the numbers in cells A1 to A5.

Excel

=SUM([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.

Adding only two cells instead of a range.

Using semicolon ';' which is not valid for ranges.

The SUM function adds all numbers in the range A1 to A5. The correct range syntax is A1:A5.

2fill in blank

medium

Complete the formula to sum the values in cells B2, B3, and B4.

Excel

=SUM([1])

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

AB2,B3,B4

BB2+B3+B4

CB2;B3;B4

DB2-B4

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus signs '+' inside SUM instead of commas.

Using semicolons ';' which is invalid in this context.

Using a dash '-' which is not a valid separator.

The SUM function can add multiple cells separated by commas. So B2,B3,B4 sums those three cells.

3fill in blank

hard

Fix the error in the formula to sum cells C1 to C3.

Excel

=SUM(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 '-' which subtracts values instead of ranges.

Using commas or semicolons which separate arguments, not ranges.

The correct way to specify a range in Excel is with a colon ':'. So C1:C3 sums cells C1 through C3.

4fill in blank

hard

Fill both blanks to sum cells D1 to D4 and cell D6.

Excel

=SUM([1], [2])

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

AD1:D4

BD1-D4

CD6

DD6:D8

Attempts:

3 left

💡 Hint

Common Mistakes

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

Using a range like D6:D8 which includes unwanted cells.

The formula sums the range D1:D4 and the single cell D6. Use a colon ':' for ranges and specify single cells directly.

5fill in blank

hard

Fill all three blanks to sum cells E1 to E3, cell E5, and cells E7 to E8.

Excel

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

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

AE1:E3

BE5

CE7:E8

DE4:E6

Attempts:

3 left

💡 Hint

Common Mistakes

Including wrong ranges like E4:E6 which are not needed.

Using plus signs '+' instead of commas to separate arguments.

The formula sums three parts: the range E1:E3, the single cell E5, and the range E7:E8. Use colons for ranges and list each part separated by commas.