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) You must have at least two tests in the formula.
C) You may have as many tests as you need in the formula.
D) All the logical tests must be true for the formatting to be applied.


A

Computer Science & Information Technology

You might also like to view...

A ListBox’s ________ property indicates the source of the data that populates the ListBox’s Items collection.

a) DataSource b) DataOrigin c) DataCreator d) DataIssuer

Computer Science & Information Technology

Prices for computer projection devices are ____ and up.

A. US$500 B. US$700 C. US$199 D. US$1,100

Computer Science & Information Technology

E6 is an example of a(n) ________ cell reference

A) mixed B) standard C) relative D) absolute

Computer Science & Information Technology

A(n) ________ is text or a graphic that displays behind text on a page

A) imprint B) trademark C) annotation D) watermark

Computer Science & Information Technology