For conditional formatting,a formula must be in the form of a(n)_____ test that results in a true or false value.
A)conditional
B)hypothetical
C)logical
D)approximate

Question

Quizplus · Accepted Answer

Conditional formatting uses logical statements to determine which cells should be formatted based on certain criteria. These logical statements evaluate to a true or false value, which determines whether the formatting is applied to the cell. Therefore, the formula used in conditional formatting must be a logical test.

For Conditional Formatting,a Formula Must Be in the Form of A(n)_____