Excel in 30 Minutes Sorting and Filtering Lists

Excel does best with sorting data when which of the following are true?

The column heading first row looks different than the data

There are no blank rows within the range of the data

There are no blank columns within the range of the data

All of the above

Filtering removes the data that doesn’t fit the filter criteria.

True

False

When creating an Advanced Filter with a criteria range, what does it mean when criteria are on two rows?

Filter on data that meets the criteria in the first row OR the second row

Filter on data that meets the criteria in the first row AND the second row

Information