Option (D) is correct.
Explanation:
C2:C6 means the cells from C2 down to C6: the five cells of column C in rows 2 to 6: the idlis sold from Monday to Friday, 34, 41, 29, 38 and 45.
=SUM(C2:C6) adds them:
34+41+29+38+45=187
So C7 shows 187: the canteen sold 187 idlis in the week.
Why the other options are wrong
- (A) 37.4 is 187÷5, which
=AVERAGE(C2:C6) would show. SUM gives the total, not the average.
- (B) 254 is the total of column B (samosas), which
=SUM(B2:B6) would show.
- (C) 41 is only the value in cell C3 (Tuesday's idlis). The range C2:C6 has five cells.