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


Answer: C

Computer Science & Information Technology

You might also like to view...

When you’re trying to make something usable, the most important thing to do is

a. reduce the number of clicks required b. eliminate the questions marks over users’ heads c. keep everything consistent

Computer Science & Information Technology

A glass picture tube is known as a ________

A) LCD B) resolution screen C) flat screen D) CRT

Computer Science & Information Technology

Which of the following is NOT a main object type in an Access database?

A) Query B) Template C) Table D) Module

Computer Science & Information Technology

Which of the following is NOT part of XML?

A) XML declaration B) Element C) Start tag D) Hyperlink

Computer Science & Information Technology