Question: You want to be able to restrict values allowed in a cell and need to create a drop-down list of values from which users can choose. Which feature should you use?
- Protect Worksheet
- Conditional Formatting
- Allow Users to Edit Ranges
- Data Validation
Answer: The correct answer of the above question is Option D:Data Validation