Question

To sort the Franchise Owners table first on the Metro Area field in ascending (A to Z) alphabetical order, and then on the 2020 Sales field in descending (Largest to Smallest) numerical order, which steps should you follow?

A) Use the Sort function and select Metro Area in ascending order, then 2020 Sales in descending order.

B) Choose the Sort Ascending option for the Metro Area field and Sort Descending for the 2020 Sales field.

C) Apply a custom sort with Metro Area ascending and 2020 Sales descending.

D) Manually rearrange the rows in alphabetical order for Metro Area and numerical order for 2020 Sales.

Answer 1

The correct method to sort the Franchise Owners table by Metro Area in ascending order and 2020 Sales in descending order is by applying a custom sort. Option C is the correct answer.

Step-by-step explanation:

To sort a table first by the Metro Area field in ascending order and then by the 2020 Sales field in descending order, you would typically follow a multi-step sorting process. This is often referred to as a multi-level or custom sort. In spreadsheet software such as Microsoft Excel, you can usually accomplish this by accessing the custom sorting options.

Correct answer to your query is Option C: Apply a custom sort with Metro Area ascending and 2020 Sales descending. This will first organize the Franchise Owners table so that the Metro Area field is alphabetized from A to Z. After that, within each Metro Area grouping, the 2020 Sales field will be sorted so that larger sales figures appear first, going down to the smaller figures.

Here is how you would sort the sample data provided, from smallest to largest sales figures:

1. 114,950
2. 158,000
3. 230,500
4. 387,000
5. 389,950
6. 479,000
7. 488,800
8. 529,000
9. 575,000
10. 639,000
11. 659,000
12. 1,095,000
13. 5,500,000