8
QuizMultiple Choice

Cumulative Exam — Cumulative exam

Question 8 • LHS Business Management

Which statement does NOT describe what the Conditional Formatting option in Excel 2019 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
It automatically sorts the data based on specific rules or conditions being met.

Explanation

Conditional Formatting changes how cells look when specified rules are met, such as applying a highlight or changing the font. It does not automatically sort data; sorting is a separate Excel feature. Therefore, “It automatically sorts the data based on specific rules or conditions being met” is the statement that does not describe Conditional Formatting.

AI-written and checked against the verified answer.

Previous
Next