Back to School Sale -
20% off all courses with code BTS2019
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?
No entirely blank rows in the data set
Consistent data types in the column
A good header row
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”
Select the filter and type “choc” in the search box
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.