Which characteristic of a data set is essential to be able to filter data?

Answer 1

A good header row.

Answer 2

No entirely blank rows in the data set.

Answer 3

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

Answer 4

Don’t know

Answer 5

Sort the data alphabetically and then visually scan down the list.

Answer 6

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

Answer 7

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

Answer 8

Don’t know

Answer 9

Clicking each Filter arrow, and selecting Clear from the submenu.

Answer 10

Turning off the Filter, then re-applying it.

Answer 11

Closing the workbook and re-opening it.

Answer 12

Don’t know

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