Suggested Solutions to Revision Exercises
Module: Computer Literacy Advanced (HCLT108-1)
Week number (Date): 4,(16 March 2023)
Unit covered: Unit 7 and 8 ( Microsoft Excel 2021)
Question 1 10 marks
You have been provided with the following covid-19 dataset. Answer the following questions
Country Confirmed Cases Death Cases
South Africa 230 520 12 900
United States of
America 859 620 84 293
Australia 127 451 5 890
Egypt 312 567 12 412
Zambia 89 173 2 012
Turkey 76 410 5 491
Ghana 67 616 4 903
United Kingdom 487 519 43 118
Brazil 718 432 52 617
Russia 923 071 81 508
China 980 431 79 562
1.1 Calculate the total number of confirmed cases. 2 marks
4 872 810
1.2 Calculate the total number of death cases. 2 marks
384 706
1 HCLT108-1-Jan-June2023-T&L-W4-Memo-IM-V1-13032023
Module: Computer Literacy Advanced (HCLT108-1)
Week number (Date): 4,(16 March 2023)
Unit covered: Unit 7 and 8 ( Microsoft Excel 2021)
Question 1 10 marks
You have been provided with the following covid-19 dataset. Answer the following questions
Country Confirmed Cases Death Cases
South Africa 230 520 12 900
United States of
America 859 620 84 293
Australia 127 451 5 890
Egypt 312 567 12 412
Zambia 89 173 2 012
Turkey 76 410 5 491
Ghana 67 616 4 903
United Kingdom 487 519 43 118
Brazil 718 432 52 617
Russia 923 071 81 508
China 980 431 79 562
1.1 Calculate the total number of confirmed cases. 2 marks
4 872 810
1.2 Calculate the total number of death cases. 2 marks
384 706
1 HCLT108-1-Jan-June2023-T&L-W4-Memo-IM-V1-13032023