An Analytics Manager, Lawrence, Wants to Clean the Following Dataset

question 56

Multiple Choice

An analytics manager, Lawrence, wants to clean the following dataset using Excel's Conditional Formatting tool. What steps should he take if he wants to make sure that any suppliers that have more than 8% returns should not receive a quality rating of 5? Highlight those cells using red.

• A) Select D6:D17; Rule type: Formula, enter =AND(F6=5,H6>0.08); Color red.
• B) Select D6:F17; Rule type: Formula, enter =AND(F6=5,H6>0.08); Color red.
• C) Select D6:D17; Rule type: Formula, enter =AND(F6=5,H6<0.08); Color red.
• D) Select D6:F17; Rule type: Formula, enter =AND(F6=1,H6>0.08); Color red.
• E) Select D1:D17; Rule type: Formula, enter =AND(F6=5,H6=0.08); Color red.

---

Definitions:

Future Operations

Planning and actions taken regarding a company's or organization's activities, strategies, and resources intended for the foreseeable future.

Cash Flow

The total amount of money being transferred into and out of a business, especially affecting liquidity and overall financial health.

Bid Prices

The highest price that a buyer is willing to pay for a security or commodity.

Break-Even

The point at which total costs and total revenue are equal, resulting in no net loss or gain for a business.