Search SchoolNGR

Friday, 10 April 2026
Register . Login

Table 1 is a part of MS Excel worksheet which shows the mark obtained by some students ...

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?
Take Free Practice Test On 2026 JAMB UTME, Post UTME, WAEC SSCE, GCE, NECO SSCE
  • A = Average (C2:C6)
  • B = Average (C2:F2)
  • C = Average (C1:C6)
  • D = Average (C1:F1)
Correct Answer: Option A
Explanation:

Share question on: