You want to filter your data and then compare it to the original data. What is the best way to do this?

Answer 1

Create a filter by clicking “Data” - “Filter”, then turn the filter on and off with the “Filter” button on the toolbar.

Answer 2

Use “create new filter view” to filter your data, and then turn the filter on and off.

Answer 3

Make a copy of the spreadsheet and filter the copy. Switch back and forth between the two.

Answer 4

Don’t know

Answer 5

“Text contains” and write “male”.

Answer 6

“Text is exactly” and write “male”

Answer 7

“Text does not contain” and write “male”.

Answer 8

Don’t know

Answer 9

They are moved to the bottom of the list where they can be rechecked.

Answer 10

They are moved to the top of the list where they can be rechecked.

Answer 11

They are removed from the list and can’t be rechecked.

Answer 12

Don’t know

You have a filter around a list of people with their ages and genders (“male” or “female”). You only want to look at the men. Which filter condition do you use?