https://youtube.com/watch?v=NNrYIcV8QrIIn this tutorial let us see How to create dependent drop down lists in Excel You might be knowing the data validation feature in excel using which one can create…