Google Sheets Test Google Sheets Data Sorting and Filtering 2

Question 1

Which function returns a filtered subset of a range based on one or more conditions without altering the original data?

Accepted Answer

FILTER

Answer

SORT

Answer

QUERY

Answer

VLOOKUP

Question 2

In the FILTER function, how do you require that TWO conditions both be true?

Accepted Answer

Multiply the condition ranges with *

Answer

Add the condition ranges with +

Answer

Separate them with a comma inside AND()

Answer

Use the OR operator |

Question 3

What does the SORT function's third argument (is_ascending) control?

Accepted Answer

Whether the sort column is ascending or descending

Answer

Which column to sort by

Answer

Whether to include headers

Answer

The number of rows to return

Question 4

A basic filter is applied to a shared sheet. What happens for other people viewing the sheet at the same time?

Accepted Answer

They see the same filtered view, affecting everyone

Answer

Only you see the filter

Answer

The filter is removed for them

Answer

It creates a copy of the sheet

Question 5

Which feature lets you save a named, reusable filter that does NOT disturb other collaborators?

Accepted Answer

Filter views

Answer

Basic filter

Answer

Protected range

Answer

Named range

Question 6

When you sort a range that has a header row, what should you do first to avoid sorting the header?

Accepted Answer

Choose 'Data has header row' in the sort dialog

Answer

Delete the header temporarily

Answer

Freeze the entire sheet

Answer

Convert the header to bold

Question 7

What is the result of SORT(A2:B10, 2, TRUE)?

Accepted Answer

Rows sorted ascending by the values in column B

Answer

Rows sorted descending by column A

Answer

Only column 2 returned

Answer

The second row extracted