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
Which set of filtering condition returns a report with the desired data?
- Credit Card equals MoreCash OR Credit Card equals Vista AND Billing Cycle is not quarterly AND Expiration Date is less than 60 days
- Credit Card equals MoreCash OR Credit Card [equals Vista AND Billing Cycle equals monthly AND Expiration Date equals next 60 days
- Credit Card equals MoreCash AND Credit Card equals Vista AND Billing Cycle equals monthly AND Expiration Date is 60 days greater than today
- Credit Card equals MoreCash or Vista, Billing Cycle monthly, and Expiration Date equals next 60 days
Display Answer
Next Question