2012+Olympic+Games+Medals+Table

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



Produce a spreadsheet which shows this information
 * Task 1**

Sort the table by country name in alphabetical order
 * Task 2**

Watch this video which shows [|how to create formulas in Excel]
 * Task 3**

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

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


 * 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

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