Question

Test Series II Session 2020 21
ICT Class VII ICSE
MM: 20
Runs in
IPL
2019
150
Total Average
Runs Score
Runs in
IPL
2020
175
Runs in
IPL 2018
100
200
Player Name
Barry Los
Sam Harry
Karry Peos
Nany Wats
Jean Sant
Sim Pros
250
170
180
98
80
67
76
80
67
78
0
34
56
** Use formula or function to find the total, average, maximum and
minimum score.
a. Find the Total runs of each player.
b. Find the Average Score of each player.
C. Find the Maximum runs and minimum runs scored by each player in
the last row.
d. Find the count of each row.
e. Give borders to your table and highlight columns Total Runs and
Average Score and rows Maximum and Minimum score.

Answer 1

Explanation:

HEY MATE

PLEASE ASK QUESTION IN A MANNER

PLEASE DO NOT POST SUCH IRREVALENT QUESTION