Question

2.
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
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)
3. Create an excel sheet and make your home budget.
You are required to show total amount available in start of the month.
Write different titles for expenditures and amount date wise.
At the end of the month, you will show the remaining amount available by using
formulas.
(6 marks)​

Answer 1

Answer:

do u study if fdc peshawar in grade 8