Sorting Data in a List - Exercise

Contact Us or call 1-877-932-8228
Sorting Data in a List - Exercise

Sorting Data in a List

Duration: 10 to 20 minutes.

In this exercise, you will practice sorting data in a list.

  1. Open Sort.xlsx from your Excel2013.2/Exercises folder.
  2. Sort the list by Town in ascending order.
  3. Further sort the list by Square Feet in descending order.

Solution:

  1. Select any cell in the list.
  2. On the DATA tab, in the Sort & Filter group, click the Sort command:Sort Command
  3. In the Sort dialog box:
    1. Verify that My data has headers is checked.
    2. Under Column, select to sort by Town.
    3. Under Sort On, accept the default, which is Values.
    4. Under Order, select A to Z to sort ascending.
    5. Click Add Level and then:
      1. Under Column, select to sort by Square Feet.
      2. Under Sort On, accept the default, which is Values.
      3. Under Order, select Largest to Smallest to sort descending.
    6. Click OK. OK Option
Next