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

FILTER returns only the rows or columns that meet the specified conditions, leaving the source range untouched.

Question 2

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

Accepted Answer

Multiply the condition ranges with *

Answer

Multiplying condition arrays with * acts as a logical AND in FILTER, keeping rows where both are TRUE.

Question 3

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

Accepted Answer

Whether the sort column is ascending or descending

Answer

Setting is_ascending to TRUE sorts ascending and FALSE sorts descending for the given sort column.

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

A standard basic filter changes the view for all collaborators; use a Filter View to filter privately.

Question 5

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

Accepted Answer

Filter views

Answer

Filter views are saved, named filters visible only to you and do not change what others see.

Google Sheets Test Practice Test