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 contains' matches any cell that includes the given substring anywhere in its text.

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

'Filter by values' shows a checklist of the unique entries so you can toggle which ones appear.

Question 3

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

Accepted Answer

Sort A → Z

Answer

The filter dropdown includes Sort A → Z and Z → A for the column directly.

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

'Custom formula is' under Filter by condition lets you supply a formula that returns TRUE for rows to keep.

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

A filled funnel icon signals that an active filter is limiting the rows shown for that column.

Google Sheets Test Practice Test