Google Sheets Test Google Sheets Data Sorting and Filtering 2 — Questions and Answers
Question 1: Which function returns a filtered subset of a range based on one or more conditions without altering the original data?
- FILTER (Correct answer)
- SORT
- QUERY
- VLOOKUP
Correct answer: FILTER
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?
- Multiply the condition ranges with * (Correct answer)
- Add the condition ranges with +
- Separate them with a comma inside AND()
- Use the OR operator |
Correct answer: Multiply the condition ranges with *
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?
- Whether the sort column is ascending or descending (Correct answer)
- Which column to sort by
- Whether to include headers
- The number of rows to return
Correct 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.
Question 4: A basic filter is applied to a shared sheet. What happens for other people viewing the sheet at the same time?
- They see the same filtered view, affecting everyone (Correct answer)
- Only you see the filter
- The filter is removed for them
- It creates a copy of the sheet
Correct 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.
Question 5: Which feature lets you save a named, reusable filter that does NOT disturb other collaborators?
- Filter views (Correct answer)
- Basic filter
- Protected range
- Named range
Correct answer: Filter views
Filter views are saved, named filters visible only to you and do not change what others see.
Question 6: When you sort a range that has a header row, what should you do first to avoid sorting the header?
- Choose 'Data has header row' in the sort dialog (Correct answer)
- Delete the header temporarily
- Freeze the entire sheet
- Convert the header to bold
Correct 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.
Question 7: What is the result of SORT(A2:B10, 2, TRUE)?
- Rows sorted ascending by the values in column B (Correct answer)
- Rows sorted descending by column A
- Only column 2 returned
- The second row extracted
Correct 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.
Google Sheets Test Google Sheets Data Sorting and Filtering 2
Which function returns a filtered subset of a range based on one or more conditions without altering the original data?