How To Create Multi Level Dependent Drop Down List In Excel?

[PapaAustin]

Hello Excel Community, 

I am looking to create a multi level drop down menu.

Below is an example of what i am looking to create.

The website I found this example used a custom add-in. I would like to see if this can be done natively. 

In addition to what is shown below, i am also interested in having the lower tier drop down to have default value selected. 

e.g. If the top tier is selected, then the lower tiers would auto populate with default values.

Attached excel file is just an example list of choices for a drop down menu

Thank you,

[#2]

@PapaAustin 

See Create Dependent Drop Down Lists 

[#3]

Thanks! The link was very helpful.
Is there a way to make lower tier drop down menus with a first value of the options?
In my GIF example, if America is selected from the continents, then Canada would be auto-populated.

[#4]

@PapaAustin 

That would require VBA. Would that be acceptable?