Data Analysis with Microsoft Excel: Updated for Office 2007

72 Excel

Figure 2-27

Selecting

only those

records

whose price

>= $1.25

This criterion selects only those records whose price is greater than

or equal to $1.25.

4 Click the Next button.

The last step in defi ning your query is to add any sorting options. You can

specify up to three different fi elds to sort by. In this example, you decide to

sort the wheat products by the amount of calories they contain, starting with

the highest-calorie product fi rst and going down to the lowest.

To specify a sort order:

1 Select Calories from the Sort by list box.

2 Click the Descending option button. See Figure 2-28.