SIMULATION
You recently opened an online toy store. You have sold products to 500 individual customers. You are evaluating customer data and order data.
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 ascending order by the ‘PostalCode” field.
Correct Answer: See explanation below.
Explanation/Reference:
Explanation:
1. Select a cell in the “CountryOrRegion” field 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 the Sort On option, select the type of sort desired, in this case Values, to sort by text.
5. Under Order, select Custom List, then set it for customers in the United States to appear first, then the customers in Canada.
6. Then to add another column to sort by, click Add Level.
7. In the Sort dialog box, under Column in the Sort by box, Select the “StateOrProvince” field.
8. Under the Sort On option, select Values.
9. Under Order, select A to Z.
10. Add a final column by clicking Add Level.
11. In the Sort dialog box, under Column in the Sort by box, Select the “PostalCode” field.
12. Under Sort On, select Values.
13. Under Order, select Smallest to Largest.
14. Click OK.
References: https://support.office.com/en-us/article/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654
