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.

Question

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.

Quizplus · Accepted Answer

The Answer of 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.

An Analytics Manager, Petra, Wants to Clean the Following Dataset