Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q96: Conditional formatting only works for textual data.
Q97: In the skeletal structure of a pivot
Q98: If you cannot create a list,then you
Q99: The Custom Filter function can create a
Q100: Which of the following enables you to
Q102: A list contains the names of members
Q103: Using spreadsheet software,a company creates a list
Q104: The basic AutoFilter function creates _ based
Q105: A(n)_ takes the most steps to create,but
Q106: A _ is a description of a