A range can be used in a Boolean logical AND or OR function if the range refers to cells containing ____.
A) text values
B) TRUE or FALSE values
C) numeric values
D) absolute values

Question

Quizplus · Accepted Answer

A range can only be used in a Boolean logical AND or OR function if the cells in the range contain TRUE or FALSE values. If the cells contain text or numeric values, Excel will return an error. Absolute values are not relevant in this context.

A Range Can Be Used in a Boolean Logical AND or OR Function