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.

---

Definitions:

American Dollar

The official currency of the United States, also known as the USD or US dollar.

London Bank

Generally refers to banks based in London, a major international financial center, but without specifying any particular institution or its activities.

British Pound

The currency of the United Kingdom, which is one of the world's major currencies traded on foreign exchange markets.

U.S. Dollar

The official currency of the United States, widely used as a benchmark and reserve currency globally.