Question

You tried to sort your spreadsheet by the values in a particular column. 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 sort the entire spreadsheet? Select all that apply.



The Sort sheet option



The Sort by row option



The Create filter view option



The SORT function


1 point

Answer 1

The Sort sheet option — Yes
The Create filter view option — Yes
The SORT function — Yes

Explanation: "Sort sheet" sorts all rows in place. Creating a filter or filter view lets you sort a column while keeping entire rows together. The SORT() function can return an entire range sorted by the chosen column. "Sort by row" is for horizontal (left‑to‑right) sorting and won't fix the typical column-based misalignment.