How can you sort data in a spreadsheet?

• A. You can only sort by color
• B. You can sort a range of cells in ascending or descending order by selecting the relevant cells and using the Sort range or Sort sheet options
• C. Sorting is automatic and cannot be controlled
• D. You must copy data to a new sheet before sorting

Answer: (B)

Sorting rearranges rows based on the values in a chosen column, in either ascending or descending order. To do this, select the range of cells you want to sort (including all related columns), then use the sort command from the menu—Sort range or Sort sheet. Choose the column to sort by and pick ascending or descending. If your data has a header row, tell the tool that so the header stays at the top. When you sort the range, each row’s data moves together, preserving the row-level connections. You can also sort by multiple columns to establish a primary and secondary order. Options like sorting by color are just specific features, and sorting automatically or needing a separate sheet aren’t typical approaches for organizing data.