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

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.