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:

Profit

The financial gain achieved when the revenues obtained from business activities exceed the expenses, costs, and taxes associated with maintaining the activity.

Commodity

A primary item used in trading that is replaceable with other items of the same type.

Maximise

To increase to the greatest possible amount or degree.

Input

Resources or factors used in the production process to generate output, such as labor, capital, and materials.