Question
Download Solution PDFWith 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:
Answer (Detailed Solution Below)
Option 1 : A, C and D Only
Detailed Solution
Download Solution PDFThe 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.