Search for courses or lessons
Redeem a coupon
Start free trial
Which of the following data characteristics is critical in order to allow efficient filtering of data?
A good header row
No entirely blank rows in the data set
Consistent data types in the column
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.
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?
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
© 2019 GoSkills Ltd.
Skills for career advancement