Asked by Shalini Ballur on Jul 16, 2024
Verified
Which of the following conditional formatting types can you apply to use red fill to indicate cells that have higher values and green fill to indicate lower values?
A) Icon Sets
B) Color Scales
C) Above/Below Average
D) Gradient Bars
Color Scales
A data visualization tool used in spreadsheet and data analysis software to represent data values with a range of colors, facilitating easier interpretation.
Icon Sets
A collection of thematic icons used to visually represent files, programs, or functions on a computer interface.
Above/Below Average
An analytical comparison indicating whether a value is greater than (above) or less than (below) the statistical average of a data set.
- Employ Excel's conditional formatting feature to conduct a visual analysis of data.
Verified Answer
JS
Julianne Sol CruzJul 18, 2024
Final Answer :
B
Explanation :
Color Scales can be used to apply a gradient of colors to a range of cells based on their values. The default color scale uses shades of green for lower values and shades of red for higher values.
Learning Objectives
- Employ Excel's conditional formatting feature to conduct a visual analysis of data.