Back to lesson
1. Which of the following data characteristics is critical in order to allow efficient filtering of data?
Consistent data types in the column
No entirely blank rows in the data set
A good header row
2. If you had a list of confectionery items in column A, what would be the most efficient route to find anything containing “Chocolate”?
Select the filter > Text filters > Contains and then enter “Chocolate”
Sort the data alphabetically, then visually scan the list.
Select the filter and type “choc” in the search box
3. If you end up with too many filters on a table and lose confidence that all items are showing, which method would be quickest to give you the most confidence that all filters are reset?
Closing the workbook and re-opening it.
Clicking each filter arrow, and selecting Clear from the submenu
Turning off the filter, then re-applying it
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement