Which describes creating a data validation drop-down list?

Which describes creating a data validation drop-down list?

• A. Use VLOOKUP
• B. Use PivotTable
• C. Create a list of allowed values and apply data validation > List
• D. Use Conditional Formatting

Answer: (C)

A data validation drop-down list works by restricting input to a predefined set of values. To create it, you first make a list of the allowed values somewhere in the workbook (a column or a named range). Then apply data validation to the target cell(s) and choose the List option, pointing it to that list. The cell will show a dropdown arrow, letting users pick from the allowed values and preventing entries outside that list. This improves consistency and reduces typos. The other options serve different tasks: VLOOKUP retrieves data based on a lookup value, not to constrain what can be entered; PivotTable summarizes data, not restricts input; Conditional Formatting changes appearance based on conditions, not the actual allowed entries.

A data validation drop-down list works by restricting input to a predefined set of values. To create it, you first make a list of the allowed values somewhere in the workbook (a column or a named range). Then apply data validation to the target cell(s) and choose the List option, pointing it to that list. The cell will show a dropdown arrow, letting users pick from the allowed values and preventing entries outside that list. This improves consistency and reduces typos.

The other options serve different tasks: VLOOKUP retrieves data based on a lookup value, not to constrain what can be entered; PivotTable summarizes data, not restricts input; Conditional Formatting changes appearance based on conditions, not the actual allowed entries.