Question

Question 6
A data analyst in human resources uses a spreadsheet to track employee work anniversaries. What spreadsheet tool can they use to add color to the cells containing the name of any employee who has worked for the business for at least five years?




Conditional formatting



Add color



CONVERT



Data validation


1 point

Answer 1

Conditional formatting

Use a conditional formatting rule (e.g., based on hire date or a formula that checks years >= 5) to automatically color the names of employees with at least five years' service.