Question

In the Sort dialog box, you can utilize up to _______ nested levels of sort criteria.

a) 3
b) 5
c) 10
d) Unlimited

Answer 1

The Sort dialog box allows up to 64 nested levels of sort criteria, enabling detailed sorting on multiple levels.

Step-by-step explanation:

In the Sort dialog box, you can utilize up to 64 nested levels of sort criteria. This allows you to sort data in a spreadsheet or database on multiple levels, creating a hierarchy of sort conditions. For instance, you could first sort a list of names alphabetically by last name, then by first name, and perhaps even by a third criterion like city or birth date. As you increase the number of nested levels, the data becomes more finely sorted according to the additional criteria.