Which of the following will you select as X in the series of clicks to add a color scale to a range of cells: (Select)Range of cells Home tab Styles group Conditional formatting X (select)Subtype ?
A) Icon Sets
B) Color Scales
C) Top/Bottom Rules
D) Highlight Cells Rules

Question

Which of the following will you select as X in the series of clicks to add a color scale to a range of cells: (Select)Range of cells > Home tab > Styles group > Conditional formatting > X > (select)Subtype ?
A) Icon Sets
B) Color Scales
C) Top/Bottom Rules
D) Highlight Cells Rules

Quizplus · Accepted Answer

To add a color scale to a range of cells, we need to select the range of cells first, then go to Home tab > Styles group > Conditional formatting and then select the option "Color Scales" under "X."

Which of the Following Will You Select as X in the Series