AutoSum shortcut in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to use the AutoSum shortcut in Excel to sum cells A1 to A5.

Excel

=SUM([1])

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

ASUM(A1, A5)

BA1+A5

CA1:A5

DA1-A5

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus signs instead of a range.

Trying to subtract cells instead of summing.

Using incorrect function syntax.

The correct way to sum a range of cells from A1 to A5 is to use the range notation A1:A5 inside the SUM function.

2fill in blank

medium

Complete the formula to sum the numbers in cells B2 through B10 using the AutoSum shortcut.

Excel

=SUM([1])

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

AB2:B10

BSUM(B2, B10)

CB2+B10

DB2-B10

Attempts:

3 left

💡 Hint

Common Mistakes

Using minus sign instead of colon.

Adding only the first and last cells.

Using SUM inside SUM incorrectly.

To sum a range of cells from B2 to B10, use the range notation B2:B10 inside the SUM function.

3fill in blank

hard

Fix the error in the formula to correctly sum cells C1 to C7 using AutoSum.

Excel

=SUM([1])

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

AC1+C7

BC1-C7

CSUM(C1, C7)

DC1:C7

Attempts:

3 left

💡 Hint

Common Mistakes

Using subtraction or addition instead of range.

Trying to sum only two cells instead of the whole range.

The correct range to sum cells C1 to C7 is C1:C7. Using a minus or plus sign will not sum the entire range.

4fill in blank

hard

Complete the code to create a formula that sums cells D3 to D8 using AutoSum.

Excel

=SUM([1]:D8)

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

AD3

BD8

C:

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using a minus sign instead of a colon.

Putting the end cell before the colon.

The correct formula uses the start cell D3, then a colon : to indicate the range, followed by the end cell D8. Here, the blanks are for the start cell and the colon.

5fill in blank

hard

Fill both blanks to write a formula that sums cells E1 to E6 using AutoSum.

Excel

=SUM([1]:[2])

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

AE1

B:

CE6

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using a minus sign instead of a colon.

Swapping the start and end cells.

Leaving out the colon.

The formula sums from cell E1 to E6 using the colon : to specify the range. The blanks correspond to the start cell, the colon, and the end cell.