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:

Throughput

The quantity of goods and materials passing through a system or process in a given period, often used to measure the efficiency of production processes.

Inventory Rate

The speed at which inventory is sold or used over a particular period, often indicating the efficiency of inventory management.

Review Interval

The scheduled period between evaluations of a process, system, or performance, allowing for adjustments and improvements.

Safety Inventory Levels

Quantities of stock kept on hand to protect against variability in demand or supply, ensuring product availability.