3
AssignmentMultiple Choice

Advanced Formatting

Question 3 • {CR} Computer Applications II

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