The final medals table for the 2012 Olympic Games in London is as follows:

2012 Medals Table.jpg


Task 1
Produce a spreadsheet which shows this information

Task 2
Sort the table by country name in alphabetical order

Task 3
Watch this video which shows how to create formulas in Excel

Task 4
Add a column which uses a formula to calculate the total number of medals won by each country in the table.

Task 5
Sort the table by the total number of medals won

Task 6

Add a column which uses a formula to calculate points for each country as follows:
  • Gold medal = 3 points
  • Silver medal = 2 points
  • Bronze medal = 1 point

Task 7
Sort the table by the total points as calculated in Task 6 above