Question

How can you restrict users to only select the options from a drop-down on a specific cell range?

A. Data Validation
B. Drop-down Lock
C. Range Restriction
D. Cell Limitation

Answer 1

In Excel, you can use `data validation` to restrict users to select options from a drop-down list.

The correct answer is A. Data Validation.

Step-by-step explanation:

The correct answer to this question is A. Data Validation. In Microsoft Excel, you can restrict users to select options from a drop-down list using data validation. Here are the steps to achieve this:

• Select the cell or range of cells where you want to create the drop-down list.
• Go to the Data tab in the Excel ribbon and click on the Data Validation button.
• In the Data Validation dialog box, select the 'List' option from the 'Allow' drop-down menu.
• In the 'Source' field, enter the options you want to include in the drop-down list, separated by commas.
• Click OK to save the data validation settings.
• Once you have set up the data validation, users will only be able to select options from the drop-down list in the specified cell range.

The correct answer is A. Data Validation.