An Analytics Manager, Mark, Highlighted All Empty Cells Using Excel's

question 51

Multiple Choice

An analytics manager, Mark, highlighted all empty cells using Excel's Conditional Formatting tool for the following dataset. What steps did he take?

• A) Select A6:H17; Rule type: Format only cells that contain, select Blanks; Color yellow.
• B) Select A6:H17; Rule type: Format only cells that contain, select 0; Color yellow.
• C) Select A1:H12; Rule type: Format only cells that contain, select Blanks; Color yellow.
• D) Select A1:H12; Rule type: Format only top or bottom ranked values, select bottom 10%; Color yellow.
• E) Select A6:H17; Rule type: Format only top or bottom ranked values, select bottom 5%; Color yellow.

---

Definitions:

Elisabeth Kübler-Ross

A Swiss-American psychiatrist known for her theory on the five stages of grief, originally described in her book "On Death and Dying".

Stages of Dying

A concept, often associated with Elisabeth Kübler-Ross, outlining the typical progression of emotional stages experienced by terminally ill patients, including denial, anger, bargaining, depression, and acceptance.

Rumination

The process of continuously thinking about the same thoughts, which tend to be sad or dark, contributing to negative thinking patterns.

Gerontocracy

A form of social structure or government in which the ruling authority is vested in the elderly or the oldest members of the society.