Confirming your payment

Skip to content

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

Meenakshi coaches the girls' cricket team of a school in Vadodara.

Question 204 marksMedium

Meenakshi coaches the girls' cricket team of a school in Vadodara. In each net session every batter faces 60 balls, and Meenakshi counts the good shots: balls hit cleanly off the middle of the bat. She types the counts for six batters into a spreadsheet to see who is improving. Rows 2 to 7 hold the batters, columns B to E hold their good shots in Sessions 1 to 4, and column F is kept for each batter's total, which she has not filled in yet.

Girls practising in school cricket nets, one batting and one bowling, with others waiting with pads and bats

Spreadsheet snapshot, columns A to F and rows 1 to 7: Batter, Session 1 to Session 4, Total; Aarti 34, 12, 45, 29; Bhavna 18, 40, 22, 36; Charu 50, 8, 31, 27; Diya 25, 33, 41, 19; Esha 9, 56, 14, 37; Fatima 42, 21, 28, 35; the Total column is empty

(i) Which cell holds Diya's good shots in Session 3?

(ii) Write the formula Meenakshi should type in cell F3 to find Bhavna's total, and the value it will show.

(iii) Write a formula for the average number of good shots of the six batters in Session 4, find its value, and say whether Session 4 had the highest average of the four sessions.