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

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.