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:

Birth Weight

The weight of a baby at the moment of its birth, an important indicator of neonatal health and development.

Months

Units of time, typically used in calendars, that approximately correspond to the period of the lunar cycle.

Master's Degree

An advanced level of college or university degree, typically following a bachelor's degree and requiring additional study.

Breast-feed

The act of feeding a baby with milk directly from the mother's breasts, providing ideal nutrition and immunity.