Creating Dependent Drop-Down Lists in Excel

This video tutorial explains how to create multiple dependent drop-down lists in Excel. It begins with setting up lists for car makes and models, then demonstrates how to create the first drop-down list using data validation. The tutorial continues by showing how to make subsequent lists dependent on previous selections using the INDIRECT function. The video concludes with testing the lists and providing additional resources for further learning.

What are the two car makes mentioned for the first drop-down list?

• Toyota and Ford

• Chevrolet and Tesla

• Hyundai and Honda

• Nissan and BMW

If Hyundai is selected as the make, which of the following is NOT a model option?

• Sonata

• Genesis

• Elantra

• Civic

What function is used to make the second drop-down list dependent on the first?

• INDIRECT

• VLOOKUP

• MATCH

• INDEX

Which cell is used as the reference for the second drop-down list?

• C14

• D14

• B14

• A14

What is the purpose of naming ranges in the context of dependent drop-down lists?

• To ensure the drop-down lists are dependent

• To sort data alphabetically

• To create a pivot table

• To apply conditional formatting

Which Excel feature is used to create a drop-down list?

• Data Validation

• Conditional Formatting

• Data Analysis

• Goal Seek

What is the third drop-down list dependent on?

• The first list

• A named range

• A fixed range

• The second list

Which color is NOT an option for the Honda Accord model?

• Green

• White

• Blue

• Purple

What should you do if you want to find more tutorials from the instructor?

• Ask a friend

• Visit a local library

• Search on Google

• Check the video description for links

Which of the following subjects does the instructor NOT have videos on?

• Physics

• Geometry

• Algebra

• Cooking