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:

Right Lateral

A position where an individual lies on their right side, often used in medical settings to aid in patient comfort or for specific examination purposes.

Metered-Dose Inhaler

A device that delivers a specific amount of medication to the lungs, in the form of a short burst of aerosolized medicine that is inhaled by the patient.

Systemic Effects

Effects of a medication or disease that are not localized but impact the entire body.

Tachycardia

A condition where the heart rate exceeds the normal resting rate, typically defined as a heart rate over 100 beats per minute in adults.