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

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 uses conditional formatting to make the following changes: change the background color of the cells with current salary of $3000 to $4000 to yellow, change the font color, generate data bars on each cell, and highlight the cells containing the names with blue color. In this scenario, which of the following changes will be applied first?

A) Generating data bars
B) Changing the color of the font
C) Changing the background color of the cells to yellow
D) Highlighting the background of the cells with blue color