Computers and Technology

Caitlyn Bonilla

29 December, 01:14

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