Question

Sania has a worksheet that contains the time taken by 25 swimmers in a swimming competition with four rounds.The four sets of timings are in the cell B2-B26,C2-C26,D2-D26 and E2-E26respectively. List the steps for each of the following task.
a)Display the average time taken by each member over the for rounds in row F.
b)Filter the data according to the average time taken by the swimmers.Display the shortest time first.
c)Show only those swimmers who could swim in an average time of 25 seconds.

Answer 1

please see on net for best answers

Answer 2

Answer:

=Average(B2:C2)

Explanation:

because it contains average range between the cells