In Excel, can I have a drop down menu that changes other cells?

Only in Excel 2001 for Mac. Microsoft noted how useful that would be, so they removed that feature totally. The reason for this is that microsoft hired people that could have done it themselves but had decided that while the press thought it would be good enough to see that they were not really serious about answering your question and left wondering if your still reading this.