Question

You’re a data analyst working with a team to analyze data. One of your team members shows you a spreadsheet they’ve sorted, but you notice that one of the columns doesn’t seem to be correctly associated with the rest of the dataset. On closer examination, you realize that only that column was sorted, instead of the entire sheet. How can you and your team member sort the entire sheet? Select all that apply.



The Create filter view option



The SORT function



The Sort by row option



The Sort sheet option


1 point
10

Answer 1

Correct answers: The Create filter view option, The SORT function, and The Sort sheet option.

Why:
- Sort sheet option (Data > Sort sheet by column ...) sorts the entire sheet (all columns stay aligned) by the chosen column.
- Create filter view (or the regular filter) lets you sort a column using the filter dropdown and it will reorder full rows, not just that single column.
- The SORT function (=SORT(range, sort_column_index, TRUE/FALSE)) returns a fully sorted array of the whole range (note: it outputs to a new location).

Why not "Sort by row option":
- "Sort by row" is for left-to-right sorting (reordering columns by a row) and is not the standard way to sort entire rows by a column; it won’t fix the one-column-only sort problem.