1. 1

    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?

  2. 2

    Suppose column A contains a list of confectionery items. Which is the most efficient method to find anything containing “Chocolate”?

  3. 3

    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?