Computer 7 Sorting & Filtering in Excel

The rearrangement of data in ascending (A-Z) or descending (Z-A) orders is called _______________ .

• Filtering

• Clear Rules

• Sorting

• Custom Filter

When data is arranged in ascending or descending order for only 1 column is called __________ .

• Multiple Column Sorting

• One Bar Sorting

• Single Column Sorting

• None of the above

Sorting is done in ___________ ways .

• One

• Two

• Three

• Four

The arrangement of data in Z to A will arrange the data in __________ order.

• Ascending

• Descending

sorting makes the data______________ to read.

• difficult

• easier

• complex

Which option is used to arrange data in order.

• insert

• order

• sort and filter

The Sort & Filter option is present under which tab of Microsoft Excel?

• Insert Tab

• Data tab

To quickly sort a list based on one column, on the Home tab , in the Editing group , click ___________ .

• Filter

• Sort and Filter

• Sort

• Review