Which command sorts data A to Z by the Category column?

Which command sorts data A to Z by the Category column?

• A. Home tab, Styles group, Format as Table
• B. Data tab, Data Tools group, Remove Duplicates
• C. Review tab, Changes group, Track Changes
• D. Data tab, Sort & Filter group, A to Z

Answer: (D)

Sorting data alphabetically by a column rearranges entire rows so that the values in that column go from A to Z, while keeping each row’s data together. To do this in Excel, go to the Data tab, in the Sort & Filter group click the A to Z button. This performs an ascending alphabetical sort on the selected column (Category). If you need to ensure you sort specifically by Category, you can use the Sort dialog to choose Category as the sort column, but the A to Z control provides the quick, standard ascending sort. The other options don’t sort by a column: Format as Table changes the display to a table, Remove Duplicates removes repeated rows, and Track Changes reviews edits.

Sorting data alphabetically by a column rearranges entire rows so that the values in that column go from A to Z, while keeping each row’s data together. To do this in Excel, go to the Data tab, in the Sort & Filter group click the A to Z button. This performs an ascending alphabetical sort on the selected column (Category). If you need to ensure you sort specifically by Category, you can use the Sort dialog to choose Category as the sort column, but the A to Z control provides the quick, standard ascending sort. The other options don’t sort by a column: Format as Table changes the display to a table, Remove Duplicates removes repeated rows, and Track Changes reviews edits.