Table 1 is a portion of a Microsoft Excel Worksheet which shows the marks obtained by some students in an examination.
| A | B | C | D | E | F |
| 1.NAME OF STUDENT | ENGLISH LANG | MATHEMATICS | DATA PROCESSING | COMP. STUDIES | CIVIC EDUCATION |
| 2.ANENE LORRETA | 65 | 90 | 70 | 85 | 65 |
| 3.BAKARE IMAM | 60 | 65 | 75 | 80 | 75 |
| 4.ENEM GRACE | 75 | 65 | 65 | 75 | 60 |
| 5.MOHAMMED DEJI | 65 | 60 | 65 | 60 | 60 |
| 6.ONYEBUEKE DEBORAH | 89 | 65 | 60 | 65 | 65 |
Which of the following formulas can be used to find the average score for ENEH GRACE?
-
=AVERAGE(B4:F4)
- =AVERAGE(B4:B6)
- =AVERAGE(A4:F4)
- =AVERAGE(B5:F5)
The correct answer is: A
Explanation
=AVERAGE(B4:F4)