LinkedIn Microsoft Excel Certification

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?

October 28, 2022 Editorial Staff

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

← An organization chart, which shows the hierarchy within a compmay or oraginization, is available as _____ that is include with Excel.
To round up a value to the nearest increment of your choice, such as the next five cents, what function should you use? →