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