24
QuizMultiple Choice

Pivot Tables and Pivot Charts — Cumulative exam

Question 24 • Computer Applications - Office 2016 - EL3520 A

Which statement describes what the Conditional Formatting option in Excel 2016 allows users to do?

Answer
A
It automatically applies formatting based on specific rules or conditions being met.
B
It automatically applies highlighting to selected cell ranges based on specific rules or conditions being met.
C
It automatically changes the font of selected cell ranges based on specific rules or conditions being met.
D
All of the options listed are correct.

Explanation

Conditional Formatting applies formatting automatically when cells meet specified rules or conditions. The formatting can include highlighting or changing the font in selected cell ranges, so A, B, and C all describe things it can do. Therefore, “All of the options listed are correct” is the best answer.

AI-written and checked against the verified answer.

Previous
Next