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?

Answer 1

Consistent data types (e.g. text versus numbers) in the column

Answer 2

A good header row

Answer 3

No entirely blank rows in the data set

Answer 4

Don’t know

Answer 5

Select the Filter and type “choc” in the search box

Answer 6

Select the Filter, then click Text Filters and select Contains... and enter “Chocolate”

Answer 7

Sort the data alphabetically and then visually scan down the list

Answer 8

Don’t know

Answer 9

Clicking the Filter arrow on each column, and selecting Clear from the submenu

Answer 10

Closing the workbook and re-opening it

Answer 11

Turning off the Filter, then re-applying it

Answer 12

Don’t know

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