Answer:
c) Data validation
Step-by-step explanation:
Data validation in Excel allows you to create rules or criteria that restrict what type of data can be entered into a cell. In the context of determining the status of an employee (current, retired, terminated), data validation can be used to ensure that only specific values related to employee status are entered accurately.
By setting up data validation, you can create a drop-down list of options such as "current," "retired," and "terminated." This ensures consistency and accuracy in recording employee statuses throughout the spreadsheet. Users can select from the predefined options in the drop-down list, reducing the risk of errors or inconsistencies in data entry. This method provides a structured and efficient way to manage and analyze employee information.
