You want to arrange the data in column A in ascending order. Which of the following commands would you use in MS Excel 2010?
A
Sort
B
Filter
C
Consolidate
D
Group
Correct Option:
A
Explanation
Sorting arranges data according to a chosen order—for example A to Z, smallest to largest, or oldest to newest. Filtering, by contrast, hides rows that do not satisfy specified criteria.
