A ________ in Excel's Conditional Formatting changes the Fill color of every cell by using a gradation of two or three different colors. ________ means more extreme.
A) color scale; Darker
B) heat map; Darker
C) color map; Lighter
D) color scale; Lighter
E) color map; Darker

Question

Quizplus · Accepted Answer

The correct term for this type of formatting is a "color scale," which uses a gradation (or scale) of colors to show the relative values in a range of cells. The default color scale in Excel starts with a lighter color (such as yellow) for low values, moves to a medium color (such as orange) for mid-range values, and ends with a darker color (such as red) for high values. Therefore, the correct answer is A, as the words "gradation" and "more extreme" indicate that the answer relates to a color scale that becomes darker for higher values.

A ________ in Excel's Conditional Formatting Changes the Fill Color