Confirming your payment

Skip to content

Competency-Based Questions (CBQ) · Question 27 of 40

Kiran keeps his school canteen's sales in a spreadsheet: rows 2 to 6 are Monday to Friday, and column C holds the…

Question 271 markMCQHard

Kiran keeps his school canteen's sales in a spreadsheet: rows 2 to 6 are Monday to Friday, and column C holds the number of idlis sold. On Tuesday 41 idlis were sold, but Kiran typed it in cell C3 as 14. He then types =AVERAGE(C2:C6) in cell C7.

Spreadsheet snapshot, columns A to D and rows 1 to 7: Day, Samosas, Idlis, Juice; idlis column C shows 34, 14, 29, 38, 45 for Monday to Friday; row 7 says Average and cell C7 is empty and highlighted

What number does cell C7 show?

Select your answer
  • (A) 37.4

  • (B) 10.4

  • (C) 32

    Correct answer
  • (D) 160