Confirming your payment

Skip to content

Practice Questions · Question 7 of 20

Coach Rekha keeps the runs scored by 7 players of her cricket club in a spreadsheet.

Question 71 markMCQMedium

Coach Rekha keeps the runs scored by 7 players of her cricket club in a spreadsheet. Column A has the players' names, and columns B to F have their runs in Matches 1 to 5. Kavya's runs are in row 4.

Spreadsheet with columns A to F and rows 1 to 8: row 1 has the headings Player, Match 1 to Match 5; rows 2 to 8 have the runs of Arjun, Bhumi, Kavya, Dev, Esha, Faiz and Gauri

Rekha wants cell G4 to show Kavya's average runs per match. Which formula should she type in G4?

Select your answer
  • (A) =AVERAGE(B4:F4)

    Correct answer
  • (B) =SUM(B4:F4)

  • (C) =AVERAGE(B4:B8)

  • (D) =AVERAGE(B4:F8)