Question

choose the correct answer. what type of conditional formatting was used in column b? highlight cells > 30 directional arrow icon set data bars color scales

Explanation:

Conditional formatting in Excel allows users to apply formatting based on cell values. Icon sets are a type of conditional formatting that use icons (like arrows, traffic lights, etc.) to visually represent data. In the given table, Column A has directional arrows (up - down arrows) which are part of the directional arrow icon set in Excel's conditional formatting options. Highlight cells > 30 would change the cell's format (like color) if the value is greater than 30. Data bars are horizontal bars within cells representing the value's magnitude. Color scales use color gradients to show data distribution. Since the example shows arrows, it's the directional arrow icon set.

Answer:

Directional Arrow Icon Set