Excel Dropdown List | Dataford Interview Questions

How would you make a dropdown list in Excel?

Return the valid option labels that should populate the dropdown, then describe how the resulting list would be connected to Excel Data Validation.

Output

One row per valid dropdown option with columns option_label and display_order
Include active, non-null, non-empty options only
Order by display_order ascending, then option_label ascending

dropdown_options

Column	Type	Description
option_idPK	INT	Unique identifier for the dropdown option
option_label	VARCHAR(100)	Text displayed as a dropdown choice
display_order	INT	Preferred position in the dropdown list
is_active	BOOLEAN	Whether the option is currently available

Your question is Excel Dropdown List. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

How would you make a dropdown list in Excel?

Return the valid option labels that should populate the dropdown, then describe how the resulting list would be connected to Excel Data Validation.

One row per valid dropdown option with columns option_label and display_order
Include active, non-null, non-empty options only
Order by display_order ascending, then option_label ascending

dropdown_options

Column	Type	Description
option_idPK	INT	Unique identifier for the dropdown option
option_label	VARCHAR(100)	Text displayed as a dropdown choice
display_order	INT	Preferred position in the dropdown list
is_active	BOOLEAN	Whether the option is currently available

Your question is Excel Dropdown List. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.