This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full 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
- Spring '05