Joolas is a small makeup company. In an Excel spreadsheet, they track each sales transaction. They often want to extract, or "filter out," a subset of their sales data. For example, they often want to identify sales transactions that satisfy the following conditions:
All transactions in which Jen sold lip gloss.
The ten largest transactions (by revenue).
The bottom 5 percent of transactions (by revenue) in which Colleen was the salesperson.
All 2005 lipstick transactions in which Ashley was the salesperson.
All foundation transactions in the first six months of 2005 in which Emilee or Jen was the salesperson and the average per unit price was more than $3.20.
Excel’s filtering capabilities make identifying the subset of data ...