In MS Excel, =SUM(A1:A5) calculates the:
AAverage of A1 to A5
BMaximum of A1:A5
CSum of A1 through A5
DCount of cells
Answer & Solution
Correct answer: C. Sum of A1 through A5
1. SUM aggregates numeric values in the range.
2. AVERAGE for mean, MAX for maximum, COUNT for count.
3. Hence Sum of A1 through A5.
_Source: UGC NET Paper 1 Study Book (ugc-net.com class notes) — Spreadsheets_