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

question 12

Multiple Choice

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

---

Definitions:

Group Mentoring Programs

Programs where multiple mentees are guided by one or more mentors, typically focusing on career development and professional growth.

Training

The process of enhancing the skills, knowledge, and competencies of employees to perform specific jobs.

Development

The process of improving the capacity, skills, or capabilities of individuals or communities over time for personal or societal benefit.

Careers

Careers refer to an individual's journey through learning, work, and other aspects of life that involves a series of employment positions where one can apply their skills and talents.