Back to lesson
1. Which of the following data characteristics is critical in order to allow efficient filtering of data?
No entirely blank rows in the data set
Consistent data types in the column
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 and type “choc” in the search box
Select the filter > Text filters > Contains and then enter “Chocolate”
Sort the data alphabetically, then visually scan the list.
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?
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