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.

Practice

1. What does the SUM function do in Excel?

easy

A. Adds numbers or ranges to find a total

B. Subtracts numbers in a range

C. Finds the average of numbers

D. Counts the number of cells with numbers

Solution

1. Step 1: Understand the purpose of SUM

   The SUM function is designed to add numbers or ranges of cells.

2. Step 2: Compare with other functions

   Unlike subtraction, average, or count, SUM specifically adds values.

3. Final Answer:

   Adds numbers or ranges to find a total -> Option A

4. Quick Check:

   SUM adds values [OK]

Hint: SUM always adds numbers or ranges [OK]

Common Mistakes:

• Confusing SUM with AVERAGE
• Thinking SUM counts cells
• Using SUM to subtract

2. Which of the following is the correct syntax to sum cells A1 to A5?

easy

A. =SUM(A1:A5)

B. =SUM(A1-A5)

C. =SUM(A1;A5)

D. =SUM(A1+A5)

Solution

1. Step 1: Identify correct range syntax

   Excel uses colon (:) to specify a range from A1 to A5.

2. Step 2: Check each option

   =SUM(A1:A5) uses =SUM(A1:A5), which is correct. Others use invalid separators or operators.

3. Final Answer:

   =SUM(A1:A5) -> Option A

4. Quick Check:

   Range uses colon : [OK]

Hint: Use colon : to specify ranges in SUM [OK]

Common Mistakes:

• Using minus instead of colon
• Using semicolon instead of colon
• Adding cells inside SUM

3. Given the values in cells: A1=3, A2=7, A3=2, what is the result of =SUM(A1, A2, A3)?

medium

A. 0

B. 7

C. 3

D. 12

Solution

1. Step 1: Identify values in cells

   A1=3, A2=7, A3=2 are the numbers to add.

2. Step 2: Calculate the sum

   3 + 7 + 2 = 12

3. Final Answer:

   12 -> Option D

4. Quick Check:

   3+7+2=12 [OK]

Hint: Add all cell values inside SUM separated by commas [OK]

Common Mistakes:

• Adding only first two cells
• Confusing SUM with average
• Ignoring some cell values

4. The formula =SUM(A1:A3 B1:B3) gives an error. What is the fix?

medium

A. Replace colon with semicolon: =SUM(A1;A3 B1;B3)

B. Add a comma between ranges: =SUM(A1:A3, B1:B3)

C. Remove one range: =SUM(A1:A3)

D. Use plus sign between ranges: =SUM(A1:A3+B1:B3)

Solution

1. Step 1: Identify error cause

   Ranges must be separated by commas inside SUM; missing comma causes error.

2. Step 2: Correct the formula

   Insert comma between ranges: =SUM(A1:A3, B1:B3) fixes the syntax.

3. Final Answer:

   Add a comma between ranges: =SUM(A1:A3, B1:B3) -> Option B

4. Quick Check:

   Separate ranges with commas [OK]

Hint: Separate multiple ranges with commas in SUM [OK]

Common Mistakes:

• Missing commas between ranges
• Using spaces instead of commas
• Using plus sign inside SUM

5. You want to sum only the positive numbers in cells A1 to A5, where some cells have negative values. Which formula correctly sums only positive numbers?

hard

A. =SUM(A1:A5)

B. =SUMIF(A1:A5, "<0")

C. =SUMIF(A1:A5, ">0")

D. =SUM(A1:A5>0)

Solution

1. Step 1: Understand the requirement

   We want to add only positive numbers, ignoring negatives.

2. Step 2: Choose correct function

   SUMIF with condition ">0" sums only cells greater than zero.

3. Step 3: Check other options

   =SUM(A1:A5) sums all numbers, including negatives; C is invalid syntax; B sums negatives only.

4. Final Answer:

   =SUMIF(A1:A5, ">0") -> Option C

5. Quick Check:

   SUMIF with condition ">0" sums positives [OK]

Hint: Use SUMIF with ">0" to sum positives only [OK]

Common Mistakes:

• Using SUM to add all values
• Wrong condition in SUMIF
• Trying invalid syntax inside SUM