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:

Gross Method

An accounting approach where discounts for early payment are not considered until they are actually taken by the customer.

Merchandise

Goods that are purchased for resale to customers in the normal course of business operations.

Inventory Shrinkage

The loss of products between purchase from suppliers and sale to customers, often due to theft, damage, or clerical errors.

Operating Expense

Costs associated with the day-to-day operation of a business, including rent, utilities, and salaries.