Back to lesson
1. Which characteristic of a data set is essential to be able to filter data?
Consistent data types (e.g. text versus numbers) in the column.
A good header row.
No entirely blank rows in the data set.
2. Suppose column A contains a list of confectionary items. Which is the most efficient method to find anything containing “Chocolate”?
Sort the data alphabetically and then visually scan down the list.
Select the Filter, then click Text Filters and select Contains... and enter “Chocolate”.
Select the Filter and type “choc” in the search box.
3. 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?
Clicking each Filter arrow, and selecting Clear from the submenu.
Turning off the Filter, then re-applying it.
Closing the workbook and re-opening it.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement