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

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

Correct Answer:

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Access For Free