What Is Not True About Using the AND Function in a Custom

question 58

Multiple Choice

What is not true about using the AND function in a custom conditional formatting rule?

• A)All the tests must be of the same data type, for example: all numbers or all text.
• B)All the logical tests must be true for the formatting to be applied.
• C)You must have at least two tests in the formula.
• D)You may have as many tests as you need in the formula.