Excel Module 4.3 and 4.4 Review Assignment

Which command displays data in an alphabetized or numerical order?

• Filter

• Sort

• Replace

• Arrange All

Which command provides a way to sort with multiple levels?

• Custom Sort

• Sort A to Z

• Sort Z to A

• Sort Smallest to Largest

• Sort Largest to Smallest

Which ribbon command clears the filter and the sort state for the current range of data?

• Home ribbon, Editing group, Clear Formats

• Data ribbon, Sort & Filter, Clear

• Home ribbon, Editing group, Sort & Filter, Delete

• Data ribbon, Sort & Filter, Reapply

Which ribbon command clears the filter and the sort state for the current range of data?

• Home ribbon, Editing group, Clear Formats

• Data ribbon, Sort & Filter, Delete

• Home ribbon, Editing group, Sort & Filter, Clear

• Data ribbon, Sort & Filter, Reapply

Each ____ determines the order a custom sort displays the data.

• Level

• Field

• Row

• Column

A restriction that Excel uses to determine which worksheet rows to display.

• sort

• filter

• format painter

• text color

A range of cells in a worksheet that contains related data and can be used by a lookup function.

• sort

• filter

• format painter

• table

Ascending Order

• A to Z

• Z to A

Descending Order

• A to Z

• Z to A

Ascending Order

• 1 to 10

• 10 to 1