Table 1 is a part of MS Excel worksheet which shows the mark obtained by some students in an examination. Use the table to answer questions 20 and 21.
S/N | A | B | C | D | E | F |
1 | NAME OF STUDENT | ENGLISH LANGUAGE | MATHEMATICS | DATA PROCESSING | COMPUTER STUDIES | CIVIC EDUCATION |
2 | ANENE LORRETA | 65 | 90 | 70 | 85 | 65 |
3 | BAKARE IMAN | 60 | 65 | 75 | 80 | 75 |
4 | ENEH GRACE | 75 | 65 | 65 | 75 | 60 |
5 | MOHEMMED DEJI | 65 | 60 | 65 | 60 | 60 |
6 | ONYEBUEKE DEBORAH | 89 | 65 | 60 | 60 | 65 |
Which of the following formulas would calculate the average score of the students in Mathematics?
A. = Average (C2:C6)
B. = Average (C2:F2)
C. = Average (C1:C6)
D. = Average (C1:F1)
Correct Answer: A