Which set of filtering conditions returns a report with the desired data?

A report contains columns for Customer, Billing Cycle, Credit Card, and Expiration Date. A manager requests that the report show only those customers who meet the following conditions: – The customer is on a monthly billing cycle – The credit card is either MoreCash or Vista – The credit card expires within 60 days.

Which set of filtering conditions returns a report with the desired data?
A . Credit Card equals MoreCash AND Credit Card equals Vista AND Billing Cycle equals monthly AND Expiration Date is 60 days greater than today
B . Credit Card equals MoreCash OR Credit Card equals Vista AND Billing Cycle equals monthly AND Expiration Date equals next 60 days.
C . Credit Card equals MoreCash OR Credit Card equals Vista AND Billing Cycle is not quarterly AND Expiration Date is less than 60 days
D . Credit Card equals MoreCash or Vista, Billing Cycle equals monthly, and Expiration Date equals next 60 days

View Answer

Answer: B