Question

16) By using Microsoft Excel:
a) Produce an appropriate fully labeled chart in Excel to compare the gold, silver
and bronze medals totals of the 10 countries.
(10 marks)
b) Use a suitable and fully labeled chart in Excel to reflect the contribution of
each country to the overall medals total.
(10 marks)
(Part 3 - 100 marks)
na (LOs: 3 & 4)
End of questions

Answer 1

Answer:

a

Step-by-step explanation:

a is the coerect answer for this

Answer 2

Answer:

Both charts are demonstrated in the attached images.

Step-by-step explanation:

i) Excel charts are a useful method to record extensive data and to process it conveniently. There are lot of available mathematical functions to process the data however we want to.

ii) The first chart shows ten countries that won most number of medals in Tokyo Summer Olympics 2020. The total number of gold, silver and bronze medals are tallied.

iii) The second chart shows an additional column for the percentage of total number of medals that each country won individually in Tokyo Summer Olympics 2020.

#SPJ3