Google Sheets Data Sorting and Filtering Flashcards

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

Answer: FILTER

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

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

Answer: Multiply the condition ranges with *

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

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

Answer: Whether the sort column is ascending or descending

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

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

Answer: They see the same filtered view, affecting everyone

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

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

Answer: Filter views

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

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

Answer: Choose 'Data has header row' in the sort dialog

Selecting 'Data has header row' tells Sheets to keep the top row as labels and exclude it from sorting.

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

Answer: Rows sorted ascending by the values in column B

The 2 selects the second column in the range and TRUE sorts those values ascending.