Question

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

Answer 1

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

Step-by-step explanation: