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”?
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.
Closing the workbook and re-opening it.
Turning off the Filter, then re-applying it.
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement