Latest:
LinkedIn Microsoft Excel Certification 

You want to be able 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?

Editorial Staff
  • Project Worksheet
  • Data validation
  • Conditional Formatting
  • Allow Users to Edit Ranges

The correct answer is:

  • Data validation

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

You May Also Like

How do you remove only the conditional formatting from a cell and leave all other formatting intact?

Editorial Staff 0

In a worksheet, column A contains employee last names, column B contains their middle initials (if any), and column C contains their first names. Which tool can combine the last names, initials, and first names in column D without using a worksheet formula?

Editorial Staff 0

What tool would you use to prevent the input in a cell of a date outside a specific range?

Editorial Staff 0