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

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

Don’t know

Answer 5

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

Answer 6

“Text is exactly” and write “male”

Answer 7

“Text contains” and write “male”.

Answer 8

Don’t know

Answer 9

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

Answer 10

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

Answer 11

They are moved to the top of the list where they can 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?