Question: In the file named Problem32data.xlsx, you are given information on 2,423 transactions. You believe fraud is likely if either of the following conditions is true:
In the file named Problem32data.xlsx, you are given information on 2,423 transactions. You believe fraud is likely if either of the following conditions is true:
The check amount is at least $500, and nobody authorized the check.
The check amount is at least $500, and the same person authorized and cashed the check.
Highlight all suspicious transactions.
Step by Step Solution
3.30 Rating (159 Votes )
There are 3 Steps involved in it
To highlight all suspicious transactions in Excel based on the given conditions you can use conditional formatting with formulas Heres how you can do ... View full answer
Get step-by-step solutions from verified subject matter experts
