With reference to the MS Excel worksheet shown below, which of formulas A-E…
2024
With reference to the MS Excel worksheet shown below, which of formulas A-E can be entered in cell A4 to add the values 10, 20 and 30?
A. =SUM(A1:A3)
B. =SUM(A1,A3)
C. =A1+A2+A3
D. =SUM(A1,A2,A3)
E. =SUM(A1-A3)
Choose the correct answer from the options given below:
A | B | C | |
|---|---|---|---|
1 | 10 | ||
2 | 20 | ||
3 | 30 | ||
4 |
Answer: A. A, C and D only — ConceptIn Excel, a colon between two cell references denotes the inclusive range from the first cell to the second. Commas separate individual arguments…
- A.
A, C and D only
- B.
B, C and D only
- C.
D and E only
- D.
A, C, D and E only
Attempted by 1 students.
Show answer & explanation
Correct answer: A
Concept
In Excel, a colon between two cell references denotes the inclusive range from the first cell to the second. Commas separate individual arguments supplied to a function.
The SUM function adds the values of its arguments. Outside a function, the plus sign performs addition and the minus sign performs subtraction.
Application
The range A1:A3 contains A1, A2 and A3, so =SUM(A1:A3) gives 10 + 20 + 30 = 60.
The arguments A1 and A3 exclude A2, so =SUM(A1,A3) gives 10 + 30 = 40.
The expression =A1+A2+A3 directly adds all three cells and gives 10 + 20 + 30 = 60.
The three arguments A1, A2 and A3 are all supplied to SUM, so =SUM(A1,A2,A3) gives 10 + 20 + 30 = 60.
The expression A1-A3 is evaluated first, so =SUM(A1-A3) gives SUM(10-30) = SUM(-20) = -20.
Cross-check
The five formulas produce 60, 40, 60, 60 and -20 respectively. Therefore the formulas that add all three worksheet values are =SUM(A1:A3), =A1+A2+A3 and =SUM(A1,A2,A3), corresponding to A, C and D only.