Page 8 of 9PREVNEXT

Queries V: Use And, Or, and In to set multiple conditions

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


If you type "West" in the Criteria cell under Region and >200000 in the Criteria cell under Sales, and both criteria are in the same row, what will the query find?

Salespeople who are in the West region or have sales over $200,000.

Salespeople who are in the West region and have sales over $200,000.

Salespeople who are in every region except the West, and have sales over $200,000.

You wanted a list of the 30 club members in your state who kayak. Instead, you retrieved more than 200 names: all the members in your state, regardless of their interests, and all the kayak enthusiasts in the country. What might have happened?

You used Or instead of And.

You used And instead of Or.

You didn't surround the criteria values with quotes.

You want a list of airlines that fly to Paris, Brussels, Stuttgart, or Copenhagen. The airline needs to fly to at least one of the cities, but doesn't have to fly to all the cities. You want to enter the cities in the same cell and type the operator only once. Which operator could you use?

And.

Or.

In.

Page 8 of 9PREVNEXT