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
- Sort, Collation, alphabetical order, Sort dialog box, Sales Region, 57 min