Event+5

=** The final task! **=


 * 1) Make a new sheet in the original Excel file (Olympic Medals to 2000)
 * 2) Enter fictitious data - extra points if it's funny - as perceived by your leader who is now overworked and overwrought! You must have at least ten items.
 * 3) Format the numbers according to what they are - money, date, time etc.
 * 4) Order the data from smallest to largest.
 * 5) Colour the largest red and the smallest green.
 * 6) Total the data.
 * 7) Find the average.
 * 8) Find the range (the difference between largest and smallest - using a function not your brain!)
 * 9) Create a graph of your data.

media type="custom" key="18475650"

If you click on the following link, it will take you to an [|Excel tutorial] on the basics as well as using formulas.