Google Sheets Test Google Sheets Data Sorting and Filtering 5

Question 1

Which function removes duplicate rows from a range, returning only distinct entries?

Accepted Answer

UNIQUE

Answer

FILTER

Answer

SORTN

Answer

TRIM

Question 2

What does SORTN(A2:B20, 3, 0, 2, FALSE) return?

Accepted Answer

The top 3 rows sorted descending by column 2

Answer

The bottom 3 rows by column 1

Answer

All rows in column 2

Answer

Three random rows

Question 3

To sort by more than one column (e.g., Department then Salary), which SORT syntax is correct?

Accepted Answer

SORT(range, 1, TRUE, 2, FALSE)

Answer

SORT(range, 1, 2)

Answer

SORT(range, TRUE, TRUE)

Answer

SORT(range, {1,2})

Question 4

Which combination lets you filter data and then sort the filtered result in one formula?

Accepted Answer

Wrap FILTER inside SORT, e.g. SORT(FILTER(...))

Answer

Use FILTER twice

Answer

Use SORT inside VLOOKUP

Answer

Filters cannot be combined with sort

Question 5

When FILTER finds no rows matching the condition, what does it return by default?

Accepted Answer

An #N/A error

Answer

A blank cell

Answer

A zero

Answer

The original range

Question 6

What does the SORT function do to the original source data?

Accepted Answer

Nothing — it outputs a sorted copy elsewhere

Answer

Permanently reorders the source

Answer

Deletes the source

Answer

Hides the source rows

Question 7

Which approach best filters a dataset that other collaborators are actively editing, without disrupting their view?

Accepted Answer

A FILTER formula on a separate sheet or a filter view

Answer

A basic filter on the shared range

Answer

Deleting non-matching rows

Answer

Sorting the shared range