What is the purpose of sorting data in a spreadsheet?

• A. Increase the number of rows
• B. Delete random entries
• C. Reveal new patterns and relationships within datasets
• D. Change the font of the spreadsheet

Answer: (C)

Sorting data reorganizes the rows in a spreadsheet so values appear in a chosen order. This reordering makes patterns, trends, and relationships easier to spot. For example, sorting by date lets you see how sales change over time and spot seasonal peaks, while sorting by revenue highlights the largest transactions and top customers for analysis or prioritization. Grouping similar items together by category through sorting can also reveal differences in performance across groups. Because sorting only changes the order of rows, it doesn’t add or remove data, so the number of rows stays the same. It also isn’t about changing fonts or other formatting. When sorting, it’s best to sort the entire table so related fields stay aligned, and you can apply multiple levels (primary criterion, then secondary) to uncover more nuanced patterns.