Question

Create an excel sheet of the reported COVID 19 cases in Pakistan in any
of
the five days (by observing /reading the news on COVID 19). Show the statistics of
COVID province wise on day-to-day basis for minimum five days (Hint(s): create a
table, use the appropriate formulas e.g., SUM, AVERAGE and then plot a line/bar
chart).
a)
b)
c)
Cases: Punjab, Sindh, KPK, ICT, Balochistan
Recovered: Punjab, Sindh, KPK, ICT, Balochistan
Deaths: Punjab, Sindh, KPK, ICT, Balochistan
Using IF statement formula, show which province has maximum number of total
reported cases, recovered cases and deaths.
Create a line/bar chart of the statistics province wise.
Take its print and submit it.
(8 marks​

Answer 1

Answer:

Please don't open Schools don't open