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:

Parallel Venation

A pattern of plant vein arrangement where veins run parallel to each other throughout the leaf blade.

Palmate Venation

A type of leaf venation where several main veins radiate outwards from a single point, resembling the palm of a hand, typical of some types of plants.

Phloem

The vascular tissue in plants responsible for the transport of organic nutrients, particularly sucrose, from the leaves to the rest of the plant.

Xylem

The vascular tissue in plants that conducts water and dissolved nutrients upward from the root and helps form the woody element in the stem.