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.
Correct Answer:

Verified
Correct Answer:
Verified
Q53: In a data table each row is
Q54: If you wanted to sort the days
Q55: If you need to perform complex filters
Q56: Match the following terms with their description:<br>
Q57: _ page breaks can be inserted if
Q59: By default Excel prints page in what
Q60: You cannot sort cells by their fill
Q61: You can freeze as many columns and
Q62: Match the following table style options with
Q63: Match the following terms with their description:<br>