With reference to the snapshot of MS-EXCEL worksheet given below, which of the following formule A-E when entered into cell A4 can be used to add the values 10, 20 and 30?

	A	B	C
1	10
2	20
3	30
4

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:

The correct answer is - A, C and D Only

Key Points

• Formulas for Adding Values
  • =SUM(A1:A3): This formula adds up all the values in the range A1 to A3.
  • =A1 + A2 + A3: This formula directly adds the values of cells A1, A2, and A3.
  • =SUM(A1, A2, A3): This formula sums the values of cells A1, A2, and A3.
• These formulas are correct and will yield the sum of 10, 20, and 30, which is 60.

Additional Information

• Understanding SUM Function
  • The SUM function is used to add up a series of numbers.
  • It can take a range of cells (e.g., A1:A3) or individual cell references (e.g., A1, A2, A3).
• Incorrect Formulas
  • =SUM(A1, A3): This formula will sum only the values in cells A1 and A3, not A2.
  • =SUM(A1 - A3): This formula will subtract A3 from A1 and then take the sum, which is not correct for this context.
• Understanding these details helps in correctly utilizing the functions in MS Excel for summing up values.