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

The correct answer is:

  • Data Validation

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers