DA0-001 · Question #5
A data analyst has been asked to organize the table below in the following ways: - By sales from high to low - By state in alphabetic order Which of the following functions will allow the data…
The correct answer is D. Sorting. Sorting arranges rows in a specified order based on one or more columns - it can sort numerically (sales from high to low) and alphabetically (state A to Z) simultaneously by applying multi-level sort criteria. Most spreadsheet tools (e.g., Excel, Google Sheets) allow you to…
Question
A data analyst has been asked to organize the table below in the following ways:
- By sales from high to low
- By state in alphabetic order
Which of the following functions will allow the data analyst to organize the table in this manner?
Exhibit
Options
- AConditional formatting
- BGrouping
- CFiltering
- DSorting
How the community answered
(24 responses)- C4% (1)
- D96% (23)
Explanation
Sorting arranges rows in a specified order based on one or more columns - it can sort numerically (sales from high to low) and alphabetically (state A to Z) simultaneously by applying multi-level sort criteria. Most spreadsheet tools (e.g., Excel, Google Sheets) allow you to define primary and secondary sort keys, making this straightforward. Conditional formatting changes the visual appearance of cells based on rules but does not reorder data. Grouping clusters related rows or columns together for summary views but does not reorder individual rows by a specific sequence. Filtering shows or hides rows based on criteria but does not rearrange the order of the remaining rows. Only sorting directly addresses the requirement to reorder data by multiple criteria.
Topics
Community Discussion
No community discussion yet for this question.