Question

which statement does not describe what the conditional formatting option in excel 2019 allows users to do?
○ it automatically applies formatting based on specific rules or conditions being met.
○ it automatically applies highlighting to selected cell ranges based on specific rules or conditions being met.
○ it automatically changes the font of selected cell ranges based on specific rules or conditions being met.
○ it automatically sorts the data based on specific rules or conditions being met.

Explanation:

Conditional Formatting in Excel 2019 is used for applying formatting (like highlighting, font changes) based on conditions. Sorting data is done by the Sort feature, not Conditional Formatting. So the statement that does not describe it is the one about sorting.

Answer:

It automatically sorts the data based on specific rules or conditions being met.