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