Google Sheets Test Google Sheets Data Sorting and Filtering 4

Question 1

When using 'Filter by condition', which option keeps only rows whose cell contains a specific substring?

Accepted Answer

Text contains

Answer

Text is exactly

Answer

Text starts with

Answer

Is empty

Question 2

In the filter menu, 'Filter by values' primarily lets you do what?

Accepted Answer

Check or uncheck individual unique values to show or hide

Answer

Enter a formula condition

Answer

Sort the column A to Z

Answer

Merge duplicate rows

Question 3

Which sort option is available directly from the filter dropdown menu?

Accepted Answer

Sort A → Z

Answer

Transpose range

Answer

Remove duplicates

Answer

Freeze column

Question 4

You want to filter using a formula like =G2>AVERAGE(G:G). Where do you enter it?

Accepted Answer

Filter by condition > Custom formula is

Answer

Filter by values checklist

Answer

Data validation

Answer

Conditional formatting

Question 5

What does the green funnel/filter icon on a column header indicate?

Accepted Answer

A filter condition is currently applied to that column

Answer

The column is sorted

Answer

The column is protected

Answer

The column contains errors

Question 6

After applying a basic filter, how do you return to seeing all rows?

Accepted Answer

Data > Remove filter, or clear the column conditions

Answer

Undo the entire sheet

Answer

Delete the header row

Answer

Refresh the browser

Question 7

Which condition would you use to show only rows where a date column is after 1/1/2026?

Accepted Answer

Date is after

Answer

Date is before

Answer

Is not empty

Answer

Text contains