Exam 77-420 Microsoft Excel 2013 2. Create Cells and Ranges 2.3 Order and Group Cells and Ranges: Custom Sort Lists

Data: Custom Sort Criteria What Do You See? Spreadsheets are used for financials and financials are recorded by date. Spreadsheets like Excel recognize that Months are sorted in calendar order, not alphabetically. Here are the steps: 6. Try it: Choose a Custom List Select the spreadsheet. Go to Data -> Sort & Filter ->Sort. Go to Order-> Custom List. Select: January, February, March, April... This is the List that matches our data.   Click OK, then OK again to save and close both windows. The entire list has been sorted. Not bad, huh?   Keep going...   The Computer Mama sez: In the 1980s, Fr. Paul wanted to sort 550 families on a PDP 11 computer. It took most of the night. Computers are faster now, aren’t they? Data -> Sort & Filter ->Sort-> Order-> Custom List