Practice - 5 Tasks
Answer the questions below
1fill in blank
easyComplete the formula to add the numbers in cells A1 to A5.
Google Sheets
=SUM([1]) Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using plus signs instead of a range inside SUM.
Using subtraction or multiplication instead of addition.
✗ Incorrect
The SUM function adds all numbers in the range A1:A5.
2fill in blank
mediumComplete the formula to sum the values in cells B2, B3, and B4.
Google Sheets
=SUM([1]) Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using plus signs inside SUM instead of commas.
Using a range with a dash which is invalid.
✗ Incorrect
The SUM function can add individual cells separated by commas, like B2,B3,B4.
3fill in blank
hardFix the error in the formula to sum cells C1 to C3.
Google Sheets
=SUM(C1[1]C3) Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using a dash or plus sign instead of a colon for ranges.
Using commas which list cells but do not create a range.
✗ Incorrect
The correct way to specify a range is with a colon :, so C1:C3 sums cells C1 through C3.
4fill in blank
hardFill both blanks to sum cells D1 to D4 and cell D6.
Google Sheets
=SUM([1], [2])
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using a dash instead of a colon for ranges.
Including extra cells not asked for.
✗ Incorrect
Use D1:D4 to sum the range from D1 to D4, and D6 to add the single cell D6.
5fill in blank
hardFill all three blanks to sum cells E1 to E3, cell E5, and cell E7.
Google Sheets
=SUM([1], [2], [3])
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using dashes instead of colons for ranges.
Forgetting commas between arguments.
✗ Incorrect
Use E1:E3 for the range, and E5 and E7 for the individual cells to sum all together.