A shopkeeper wants to create a sublist of customers spending less than $50 and customers spending more than $100 per purchase,out of a list of all customer-purchase amounts.Which of the following combinations of values and Boolean operators must be chosen?
A)"Greater Than" $50 or "Lesser Than" $100
B)"Lesser Than" $50 or "Greater Than" $100
C)"Greater Than" $50 and "Lesser Than" $100
D)"Lesser Than" $50 and "Greater Than" $100

Question

Quizplus · Accepted Answer

Choosing "Lesser Than $50 or Greater Than $100" would hide all entries except those of customers spending less than $50 and entries of customers spending more than $100.

A Shopkeeper Wants to Create a Sublist of Customers Spending