Grease

Computers & Technology

20 January, 07:05

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