Project 1 of 7: Tailspin ToysOverviewYou recently opened an online toy store.

1. Select a cell in the “CountryOrRegion” field on the “Customers” worksheet.

2. Select Sort from theSort & Filtergroup in theDatatab.

3. In theSortdialog box, underColumnin theSort bybox, Select the “CountryOrRegion” field.

4. Under theSort Onoption, select the type of sort desired, in this caseValues, to sort by text.

5. UnderOrder, selectCustom 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, clickAdd Level.

7. In theSortdialog box, underColumnin theSort bybox, Select the “StateOrProvince” field.

8. Under theSort Onoption, selectValues.

9. UnderOrder, selectA to Z.

10. Add a final column by clickingAdd Level.

11. In theSortdialog box, underColumnin theSort bybox, Select the “PostalCode” field.

12. UnderSort On, selectValues.

13. UnderOrder, selectSmallest to Largest.

14. ClickOK.

References:

https://support.office.com/en-us/article/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654