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

UNIQUE returns the distinct rows of a range, discarding repeated ones.

Question 2

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

Accepted Answer

The top 3 rows sorted descending by column 2

Answer

SORTN returns n rows; here 3 rows sorted by column 2 with FALSE meaning descending order.

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 accepts repeated column/direction pairs, so column 1 ascending then column 2 descending is valid.

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

Nesting FILTER inside SORT sorts the already-filtered rows, chaining both operations.

Question 5

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

Accepted Answer

An #N/A error

Answer

FILTER returns #N/A when nothing matches, unless a third argument provides a fallback value.

Google Sheets Test Practice Test