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

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Microsoft Excel Data Analysis 7th Questions!