You have a list of sales numbers in cells A1:A5. You apply a 3-icon set conditional formatting rule to show green up arrow for sales > 100, yellow sideways arrow for sales between 50 and 100, and red down arrow for sales < 50.
What icon will appear in cell A3 if the value is 75?
Think about which range 75 falls into based on the rule.
75 is between 50 and 100, so the yellow sideways arrow is shown.
You want to visually represent project completion percentages in cells B1:B10 using icon sets. Which icon set type is best to show low, medium, and high completion levels?
Look for an icon set that clearly shows three distinct levels.
3 Traffic Lights (Unrimmed) clearly shows low (red), medium (yellow), and high (green) levels, perfect for completion percentages.
You apply a 3-icon set to a range of scores with default percent-based thresholds: green icon for top 33%, yellow for middle 33%, red for bottom 33%. You want to change the yellow icon to show scores between 40 and 80 instead. What must you do?
Think about how to control exact value ranges for icons.
You can edit the icon set rule and switch from percent to number thresholds, then set 40 and 80 as the limits for the yellow icon.
You apply a 3-icon set (green up arrow, yellow sideways arrow, red down arrow) to a range containing negative and positive numbers. The default thresholds are set to percent. What icon will appear for the lowest negative value?
Lowest values get the red icon by default.
The lowest values in the range get the red down arrow icon by default in a 3-icon set.
You have 100 cells with values from 1 to 100. You apply a 3-icon set with default percent thresholds (green for top 33%, yellow for middle 33%, red for bottom 33%). How many cells will show the yellow icon?
Calculate the number of cells in the middle 33% of the range.
Top 33% means 33 cells get green, bottom 33% means 33 cells get red, so the remaining 33% (100 - 33 - 33 = 34) cells get yellow. Because of rounding, 34 cells get yellow.