31
QuizMultiple Choice

Topic Test

Question 31 • CARE_24_25_TX-Art I B

What is an example of conditional formatting?

Answer
A
Cells in a row have a yellow background.
B
Cells in a range with values under 10 have a red background.
C
Cells in a column have green text.
D
Cells in a worksheet have borders around their edges.

Explanation

Conditional formatting changes a cell’s appearance when it meets a specified rule. In choice B, cells with values under 10 receive a red background, so the formatting depends on their values. The other choices describe formatting applied without a condition.

AI-written and checked against the verified answer.

Previous
Next