Chapter 2 Working with Data 55
EXCEL TIPS
If you want to sort your list in nonnumeric order (in terms of
days of the week or months of the year), click Custom List from
the Order list box and then select one of the custom lists defi ned
for your workbook.
To sort your data by multiple levels, click the Add Level button
in the Sort dialog box and then specify the data values corre-
sponding to the next level.
Querying Data
In some cases you may be interested in a subset of your data rather than in
the complete list. For instance, a manufacturing company trying to analyze
quality control data from three work shifts might be interested in looking
•
•
Figure 2-15
The gas
station data
sorted in
descending
order to
Total
revenue
5 Click the OK button.
6 Deselect the cell range by clicking cell A1.
The stations are now sorted in order from Station 7, showing the
largest total revenue, to Station 6 with the lowest revenue. See
Figure 2-15.
