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:

Illegal Immigrants

Individuals who enter or reside in a country without the necessary permissions or legal authorization from the government.

United States

A country located in North America, known for its vast geography, diverse population, and leading position in global economic and political affairs.

Family Sponsorship

A process where a citizen or permanent resident sponsors a relative to immigrate to their country, often as part of family reunification programs.

Highly Educated

Refers to individuals who have obtained a high level of formal education, often including college or university degrees beyond the undergraduate level.