Which capability is listed as a reason for using spreadsheets?

• A. Ability to sort and filter metrics
• B. Real-time video editing
• C. Building mobile apps
• D. Storing large graphs automatically

Answer: (A)

Spreadsheets are especially useful for exploring and analyzing data. Sorting rearranges rows based on a column’s values, making it easy to see rankings, identify top or bottom performers, and compare metrics quickly. Filtering lets you hide everything that doesn’t meet certain criteria, so you can focus on the subset of data relevant to the question at hand. These capabilities are fundamental for making sense of metrics and drawing insights without altering the original data.

Real-time video editing is something you’d expect in multimedia software, not a spreadsheet. Building mobile apps requires programming and development tools, not the data-manipulation features of a spreadsheet. Storing large graphs automatically isn’t a standard spreadsheet function—charts and graphs can be created from data, but the tool doesn’t automatically manage large graph storage as a primary capability.