Go to: Level 1 2 3 4 5 6 7 8 9 10 11 12 16 13 14 15 17

Level 6: Practice

Working with Lists, part two

Sorting Data

  • Select the entire spreadsheet by clicking on the gray square at the corner of the columns and rows

  • Go to Data -> Sort

  • Choose your topics from the drop down lists.

  • Note: if the first row in your spreadsheet has labels, this is the Header Row. That's what Excel uses for the drop down boxes. If you do not have a header, you will only see Column A, Column B, etc.

Challenge Exercise

  • Open the sample Excel list, PhoneBk.xls with over 1,500 names.

  • When prompted, SAVE to My Documents

  • Go to My Documents and double click on PhoneBk.xls to open the spreadsheet in Excel

Try It

  • Sort by Classify, then City, then Last Name

  • Find the Name

  • Make a subset of data by copying all of the student records into another worksheet.