Task+2

Download the spreadsheet and save it in your folder. This is the medals won by Australians at the Olympics. Remember we are one of only three nations to allend every Olympic Games!

You are going to complete the folowing tasks with this spreadsheet:
 * 1) Find the total number of medals for each olympiad by typing =sum(highlight the three cells) So =sum(b2:b4)
 * 2) Do this for the next four rows
 * 3) NOW a trick!!! Click on E7. you will see a little black square in the bottom right hand corner. Drag this down to the last row. Let go of the mouse button and VOILA, they should all be totalled!
 * 4) Now to find the total of each kind of medal. Click on the bottom of the column. Click AUTO SUM in the ribbon (top right). Now press enter and see what happens.

Now to do some calculating
 * 1) Find the average number of gold, silver and bronze medals. There are 26 olympiads and the division sign is /.
 * 2) Find the total medals won across all olympics and find the average.
 * 3) Graph the medal data (highlight the medal data - but not the years! - select chart - select an appropriate type of chart from the chart layout tab). Make sure you include the chart and axis titles which you will find in Chart Quick Layouts (number 8) Drag the chart to the side of the screen so you can see the data and the graph.
 * 4) Challenge: See if you can colour code the graph - gold for gold medals, silver for silver medals and so on.
 * 5) Save the spreadsheet and upload to your wiki. Answer the questions below.

Some thinking..
 * 1) Look at when we have been very successful. Which Olympiads were these? Why do you think this is so?
 * 2) What do you think the reaction was to the results in 1976?