A user wants to sort data in multiple columns. Which sequence of steps will sort the data?
A select a cell in the data rangeselect the Data tab select “Sort” in the Sort and Filter groupselect the column to be sortedselect an orderclick OK
B select a cell in the data rangeselect the Data tabselect “Consolidate” in the Data Tools groupselect the column to be sortedselect an orderclick OK
C select a cell in the data rangeselect the Page Layout tabselect “Align” in the Arrange groupselect the column to be sorted select an order click OK
D select a cell in the data rangeselect the Page Layout tabselect “Effects” in the Theme groupselect the column to be sorted select an orderclick OK