2. Sort the AccountReps table first in ascending order by the name of the account rep and then in descending order by total sales so Bao can quickly identify the top sellers for each rep. How to do this in excel

Question

2. Sort the AccountReps table first in ascending order by the name of the account rep and then in descending order by total sales so Bao can quickly identify the top sellers for each rep. How to do this in excel

Answer 1

To sort the AccountReps table in Excel, follow these steps:

1. Select the entire AccountReps table.
2. Go to the Data tab on the Excel ribbon.
3. Click on the "Sort" button.
4. In the Sort dialog box, under "Sort by," choose the column "Name" and select "Ascending" as the sort order.
5. Then, click on the "Add Level" button to add a secondary sort level.
6. Under the new sort level, choose the column "Total Sales" and select "Descending" as the sort order.
7. Click "OK" to apply the sorting.

Now, the AccountReps table will be sorted first by the name of the account rep in ascending order, and then in descending order by total sales. This will help Bao quickly identify the top sellers for each rep.