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 the following question.

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 is A

No explanation has been provided for this answer.