How does one create a drop down menu for a cell to provide a specific answer. For example if it's a multiple choice question.

Hi Loreen, Thanks for the post, in answer to your question, a good way of accomplishing this is to use the Data Validation function;
Select a cell or range of cells to which you wish this operation to be used in, Go to the Menu bar and choose Data>Validation.
In the dialog box that opens, from the Allow drop down options choose List.
In the Source text box, enter your list of items separated by a comma (,)
Alternatively if you have a list already in your worksheet and you wish to use it, select the list, or enter in the range references (ie A1:A15,) click OK and you will notice a drop down arrow appear next to a selected cell in your range.
By clicking on the dropdown your list will be displayed, click on on of the items in your list to select.
I hope that has helped, if so please click the resolved link, best regards Pete
Pete Emmerson
Microsoft Office Specialist Master Instructor