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 wants to change the background color of the cell with the names of candidates whose expected salary is in the range of $6000 to $7000 per month. In this scenario, Zelda should use the _____ option in conditional formatting.
A)Color Scales
B)Top/Bottom Rules
C)Highlight Cells Rules
D)Icon Sets

Question

Quizplus · Accepted Answer

The "Highlight Cells Rules" option in conditional formatting allows users to change the cell's appearance based on specific criteria, such as a value range, which is suitable for Zelda's need to highlight cells based on the expected salary range.

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