Microsoft Office Tutorials and References
In Depth Information
FIGURE 22.9 Custom AutoFilter for Age above 40
You will find these examples in the Excel Chapter 22 file:
1. Open the Excel sheet named Review. You may be familiar with the data; you
used this sheet earlier in this chapter. Use the AutoFilter to choose female
married customers with no children.
2. Using the same sheet,
lter for all customers with an annual income over $80,
000 with purchases below $100.
3. On the sheet Review Color select all the employees with a yellow background in
column A, using the AutoFilter.