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

question 57

Multiple Choice

An analytics manager, Petra, wants to clean the following dataset using Excel's Conditional Formatting tool. What steps should she take if she wants to highlight any percentages in Column E that are not between 0% and 100% using a light blue color?

• A) Select E6:E17; Rule type: Format only cells that contain, select Cell value, then not between, then 0 and 1; Color light blue.
• B) Select A6:EH7; Rule type: Format only cells that contain, select Cell value, then less than, then 1; Color light blue.
• C) Select E6:F17; Rule type: Format only cells that contain, select Cell value, then not between, then 0 and 1; Color light blue.
• D) Select E1:E17; Rule type: Format only cells that contain, select Cell value, then more than, then 1; Color light blue.
• E) Select C6:F17; Rule type: Format only cells that contain, select Cell value, then not between, then 0 and 1; Color light blue.

---

Definitions:

Carmex

A brand known for its lip balm products designed to moisturize, heal, and protect the lips.

Noncumulative Discounts

Price reductions on purchases that do not accumulate over time, typically offered as one-time incentives.

Cumulative Quantity Discounts

Price reductions based on the total quantity of goods a customer purchases over a given time period, incentivizing larger orders.

Quoting Prices

The act of providing a potential buyer with a specific price at which goods or services can be sold, often before a deal is finalized.