Radha tries different ways to explore the alternative methods of getting the average value of the numbers as indicated in the worksheet below:
| A | B | C | D | |
| 1 | 12 | |||
| 2 | 5 | |||
| 3 | 10 | |||
| 4 |
Which of the following formulae A-E when entered in cell A4, would given an incorrect result?
(A) AVERAGE (A1 - C3)
(B) AVERAGE (A1 : C3)
(C) SUM (A1: C3) + 3
(D) SUM (A1 : C3) + 9
(E) SUM (A1, B2, C3) + 3
Choose the correct answer from the options given below:
1
(B) and (C) Only
2
(A) and (D) Only
3
(C) and (E) Only
4
(A), (B) and (D) Only