Concept:The Excel AVERAGE function finds the mean of a selected range of cells.
For Mathematics scores, identify the correct column and row range in the table.
Explanation:In the worksheet, column C is labelled MATHEMATICS.
The marks for Mathematics are entered from row 2 to row 6 for the five students.
The relevant range is therefore
C2:C6.
Excel’s AVERAGE function is written as
=AVERAGE(C2:C6).
This formula adds all scores in Mathematics and divides by the count of students.
Option B incorrectly selects row 2 across several subjects, not the whole class.
Option C includes row 1, which contains the heading “MATHEMATICS”, not a numeric score.
Option D also includes headings and only row 1, so it cannot compute the average marks.
Answer:A.
=AVERAGE(C2:C6)