Multiple Choice
Which of the following is an example of conditional formatting?
A) Highlighting cells based on their values
B) Merging the cells that have the same value
C) Adding a dropdown to the heading with the values in a list
D) Separating the text in a cell to different columns
Correct Answer:

Verified
Correct Answer:
Verified
Q50: Damien, an accountant, needs to calculate the
Q51: The Error Checking button appears on an
Q52: Identify a true statement about conditional formatting.<br>A)It
Q53: Conditional formatting can be used to:<br>A)calculate nested
Q54: John, a researcher, collects a large amount
Q56: An _ is a message that appears
Q57: The Conditional Formatting button is available on
Q58: In Microsoft Excel 2016, the formula '=IF(G5=L5,"Yes",
Q59: To access conditional formatting on Microsoft Excel,
Q60: The error value " #N/A" indicates that:<br>A)the