In a spreadsheet, how do you sort data in ascending order by a single column?

• A. Sort A to Z (ascending) on that column.
• B. Filter data.
• C. Apply conditional formatting.
• D. Create a chart.

Answer: (A)

Sorting data in a spreadsheet by a single column means rearranging entire rows so the values in that column go from smallest to largest. The command Sort A to Z (ascending) on that column applies exactly this order and moves whole rows together, so all the data in each row stays aligned. This is the right way to make the column's values increase from top to bottom while preserving the integrity of the other columns in each row. Other actions don’t reorder data: filtering hides rows that don’t meet criteria, conditional formatting changes how cells look, and creating a chart visualizes data rather than changing its order. For a clean sort, it’s best to select the full data range so every row’s related data remains linked correctly.