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:

  1. A, C and D Only
  2. B, C and D Only
  3. D and E Only
  4. A, C, D and E Only

Answer (Detailed Solution Below)

Option 1 : A, C and D Only

Detailed Solution

Download Solution PDF

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.
Get Free Access Now
Hot Links: teen patti sweet teen patti master downloadable content teen patti star apk