Microsoft
77-727 · Question #2
On the "Customers" worksheet, sort the table to order the records by the "CountryOrRegion" field, with customers in the United States first and customers in Canada second. Then sort the customers in…
Explanation: 1. On the Customers worksheet. 2. Select Sort from the Sort & Filter group in the Data tab. 3. In the Sort dialog box, under Column in the Sort by box, Select the "CountryOrRegion" field. 4. Under Sort On, Select Values, and under Order, Select Custom List, type…
Manage Tables and Lists
Question
On the "Customers" worksheet, sort the table to order the records by the "CountryOrRegion" field, with customers in the United States first and customers in Canada second. Then sort the customers in each country alphabetically (from A to Z) by the "StateOrProvince" field. Finally, sort the customers in each state or province in descending order by the "PostalCode" field.
Explanation
Explanation:
- On the Customers worksheet.
- Select Sort from the Sort & Filter group in the Data tab.
- In the Sort dialog box, under Column in the Sort by box, Select the "CountryOrRegion" field.
- Under Sort On, Select Values, and under Order, Select Custom List, type in: United States, Canada, then click Add. Click OK. Select Custom List. From Custom Lists select the one you just created.
- Under Order, Select Custom List, type in the set for customers in the United States to appear first, then the customers in Canada.
- Click Add Level.
- In the Sort dialog box, under Column in the Sort by box, Select the "StateOrProvince" field.
- Under Sort On, Select Values.
- Under Order, Select A to Z.
- Click Add Level.
- In the Sort dialog box, under Column in the Sort by box, Select the "PostalCode" field.
- Under Sort On, Select Values.
- Under Order, Select Smallest to Largest.
- Click OK.
Topics
#multi-level sort#table sort#sort order#data organization
Community Discussion
No community discussion yet for this question.