Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
You have selected a single cell in a range of data, and want to activate the filter command to filter rows out of the data set. Which characteristics must your data exhibit in order to filter correctly?
Consistent data types (e.g. text versus numbers) in the column
No entirely blank rows in the data set
A good header row
Suppose column A contains a list of confectionery items. Which is the most efficient method to find anything containing “Chocolate”?
Select the Filter, then click Text Filters and select Contains... and enter “Chocolate”
Select the Filter and type “choc” in the search box
Sort the data alphabetically and then visually scan down the list
Suppose you ended up with too many filters on a table and lose confidence that all items are showing. Which is the quickest method to ensure all filters are reset?
Turning off the Filter, then re-applying it
Clicking the Filter arrow on each column, and selecting Clear from the submenu
Closing the workbook and re-opening it