Lesson 22 - . To Sort Multiple Categories: Select Data from...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Lesson 22: Sorting Lists Page 1 By the end of this module, learners should be able to: Sort lists in ascending order Sort lists in descending order Sort multiple categories at the same time Page 2 Sorting Lists Watch the video! (1:57 min) - Tips for watching our videos. Sorting lists is a common spreadsheet task that allows you to easily reorder your data. The most common type of sorting is alphabetical ordering, which you can do in ascending or descending order. In this example, we will alphabetize the employee names . To Sort in Ascending or Descending Order: Select Data from the main menu. Select Sort . The Sort dialog box will appear. Select the category you would like to Sort by . Select Ascending to sort in alphabetical order from A to Z.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Click OK . To sort in reverse alphabetical order from Z to A, select Descending
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: . To Sort Multiple Categories: Select Data from the main menu. Select Sort . The Sort dialog box will appear. Select the category you would like to Sort by . Select Ascending to sort in alphabetical order from A to Z. In the Then by section, select the second category you would like to sort. Click OK to sort in alphabetical order and by sales region. Page 3 Challenge! If you have not already done so in a previous Challenge, download and save the Employee Sales spreadsheet. Need help? How to Download a File Open the Employee Sales spreadsheet. Sort the employee names in alphabetical order. Sort by the Sales Region and then by Employee Name . Continue to sort the different categories until you are comfortable with this feature. Save and close the spreadsheet....
View Full Document

Page1 / 3

Lesson 22 - . To Sort Multiple Categories: Select Data from...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online