Option (A) is correct.
Explanation:
Kavya's runs are in row 4, in the cells from B4 (Match 1) to F4 (Match 5). In a spreadsheet, the cells of one row are written as Start:End, so her runs are B4:F4.
The formula =AVERAGE(B4:F4) adds these 5 cells and divides by 5:
28+17+33+45+22=145
145÷5=29
So G4 would show 29, Kavya's average runs per match.
Why the other options are wrong
- (B)
=SUM(B4:F4) adds Kavya's runs and shows the total 145, not the average.
- (C)
B4:B8 is part of column B: the Match 1 runs of Kavya, Dev, Esha, Faiz and Gauri. It would show (28+9+35+20+42)÷5=134÷5=26.8.
- (D)
B4:F8 is the whole block of rows 4 to 8, that is, 25 cells for 5 players. It would show the average of all of them, 629÷25=25.16, not Kavya's average.