Case 15-2 Zelda, the Human Resource (HR) manager at ProfDot Technologies, creates a database on an Excel sheet of the names of potential candidates for a job. In addition, she enters the work experience, current salary, and expected salary against each name.
Zelda previously highlighted the cells with the names of candidate who have over two years of work experience using conditional formatting. If Zelda wants to remove the condition from the worksheet, she should use the _____ option.
A)Wrap Text
B)Edit Rules
C)Clear Rules
D)Clear Contents

Question

Quizplus · Accepted Answer

To remove conditional formatting from a worksheet, the "Clear Rules" option should be used. This option allows users to clear the conditional formatting rules that have been applied to the cells, without affecting the content of the cells themselves.

Case 15-2 Zelda, the Human Resource (HR) Manager at ProfDot