15.6k views
2 votes
To create a nested sort, which feature should you change in the Sort dialog box?

1 Answer

4 votes

Final answer:

To create a nested sort, change the 'Sort by' and 'Then by' fields in the Sort dialog box to specify the primary and secondary sort columns.

Step-by-step explanation:

To create a nested sort in an application like Microsoft Excel, you should change the Sort by and Then by fields in the Sort dialog box. These fields allow you to specify which columns to sort by and in what order. For a primary sort, you use the Sort by field to select the main column that you want to organize your data by.

To add a nested sort, you then use the Then by field to specify additional columns that you want to sort within the sorted data of the primary column. This way, if there are rows with the same value in the primary sorted column, they will then be sorted by the secondary column, and this can continue with more levels as needed.

This is where you specify the primary sorting criteria. By selecting a column or field to sort by, you can organize your data in ascending or descending order.

User Pogosama
by
8.8k points