Can the contents of a drop down box be dependent on the answers of another drop down box

I am working for a college and they want me to make an excel spreadsheet to help with appointment scheduling. We have three campuses and many departments. So they want a drop down box where you select...