Need to know the correct answer

General
1

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?

  1. Credit Card equals MoreCash AND Credit Card equals Vista AND Billing Cycle equals monthly AND Expiration Date is 60 days greater than today
  2. Credit Card equals MoreCash OR Credit Card equals Vista AND Billing Cycle equals monthly AND Expiration Date equals next 60 days.
  3. Credit Card equals MoreCash OR Credit Card equals Vista AND Billing Cycle is not quarterly AND Expiration Date is less than 60 days
  4. Credit Card equals MoreCash or Vista, Billing Cycle equals monthly, and Expiration Date equals next 60 days

Answer: 1 , This answer is also confusing, can someone clarify which one is correct ? is 1 or 2 or 4.

2

The correct answer is 4.
The filter must be: Billing Cycle = monthly, Credit Card = MoreCash or Vista, and Expiration Date is within the next 60 days.