I have seen spreadsheets that have drop down boxes that appear to be part of
a cell i.e. they don't appear to be cut and paste there. Does Excel have
this functionality, and if so, how do I use it?

I have also noticed that if you are typing an entry that you recently typed,
Excel will automatically complete the word you are typing. However, there
appears to be a limited "memory" because it does not remember entries I made
a while back. Is there a limit, and is there a way to expand how far back
it remembers?

Chris