Table 1 is a part of MS Excel worksheet that shows the marks 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?
-
= Average (C2:C6)
- = Average (C2:F2)
- = Average (C1:C6)
- = Average (C1:F1)
The correct answer is: A
Explanation
Average: To calculate the average of a range of numbers in Excel, you can use the AVERAGE function. The basic syntax for the AVERAGE function is:
=AVERAGE(number1, [number2], ...)
For example, to calculate the average of the values in cells A1 to A5, you can use the formula:
=AVERAGE(A1:A5)
Therefore OPTION A is correct.