Question

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

Explanation:

Data bars are a type of conditional formatting in spreadsheet software (like Excel) that visually represent the values in cells as horizontal bars. The length of the bar corresponds to the value in the cell relative to other values in the range. In the given image, Column B shows horizontal bars next to each score, which is characteristic of data bars. Highlight cells > 30 would typically change the cell's fill or font color if the value is greater than 30 (not showing bars). Color scales use gradients of colors to represent values (not bars). Directional Arrow Icon Set uses arrows (not bars) to represent data trends or values.

Answer:

Data bars