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.

Question

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.

Quizplus · Accepted Answer

Mark selected the range A6:H17 and used the "Format only cells that contain" rule type to select the blanks, then formatted them with the color yellow. This highlights all empty cells in the dataset.

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