Sort worksheet data

Open the SortData workbook in Excel, and then perform the following tasks:

Sort the data in the cell range B$3$:D$14$ in ascending order by the values in the

Revenue column.

Sort the data range in descending order by the values in the Revenue column.

Perform a two$-$level sort of the data range:

a$.$ In ascending order by Customer.

b$.$ In ascending order by Season.

Review the effect of the multiple$-$column sort. Be sure that you understand the

effect of the sort operation order.

Reverse the order of the fields in the Sort dialog to sort first by Season and then

by Customer.

Sort the data range by the Revenue column so that the cells that have a red fill

color are at the top of the list.

Save and close the file.