Search for courses or lessons
Redeem a coupon
Start free trial
You have selected a single cell in a range of data, and want to activate the filter command to filter rows out of the data set. Which characteristics must your data exhibit in order to filter correctly?
A good header row
Consistent data types (e.g. text versus numbers) in the column
No entirely blank rows in the data set
Suppose column A contains a list of confectionery 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 and type “choc” in the search box
Select the Filter, then click Text Filters and select Contains... and enter “Chocolate”
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?
Turning off the Filter, then re-applying it
Clicking the Filter arrow on each column, and selecting Clear from the submenu
Closing the workbook and re-opening it
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement