Computers & Technology

Camren Lutz

1 March, 17:49

A user wants to sort data in multiple columns. Which sequence of steps will sort the data?

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

select a cell in the data rangeselect the Data tabselect "Consolidate" in the Data Tools groupselect the column to be sortedselect an orderclick OK

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

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