5. Sorting in Spreadsheets

A spreadsheet can be sorted into a particular order such as showing all surnames alphabetically or listing exam marks from the highest to the lowest.

What you have to do!

Sorting Data in a Spreadsheet! Click to Go Larger Screen

1. Download the file Gradings.xls.
   
   
   
   
2. Watch Movie 5 and using the methods shown:
   1. Sort the rows in order of surname.
   2. Now sort the average scores so that the largest average appears at the top of the list.
3. Save your file.

Mark off Exercise 6 in your Progress Grids

What you should now be able to do!

• Use the sort feature in spreadsheets to sort data

• Use the sort feature to do simple sorts on one column

• Use the sort feature to do more complex sorts using multiple columns

Continue to Section 6: Making Charts