Pivot Tables and Pivot Charts — Cumulative exam

Question 30 • Computer Applications - Office 2016 - EL3520 A

Seneca has just applied conditional formatting and realizes that she has made a mistake. Which action should she take to fix the mistake?

Answer

Clear the rule she created by going to the Conditional Formatting Rules Manager dialog box and deleting the rule.

Clear all rules that have been applied to the worksheet or selected range by clicking the Clear Rules button.

Use the Undo button or Ctrl+Z.

Right-click the area where the conditional formatting rule has been applied, and select Clear Rule from the menu list.

Explanation

The quickest way to reverse a conditional formatting change made by mistake is to use Undo or press Ctrl+Z. This reverses the most recent action without requiring Seneca to find and remove rules manually. The other choices involve deleting or clearing rules rather than simply undoing the last action.

AI-written and checked against the verified answer.

More from this Course

Cumulative Exam

Instruction

Cumulative Exam