529
QuizMultiple Choice

Cumulative Exam — Cumulative exam

Question 529 • Career Explorations 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