Excel question

[mds1303]

I am new to this forum and pretty bad at using excel, however I had one question. I was hoping someone could tell me if it is possible to do the following:

There is a website that has roughly 1000 questions, with 4 answer choices, and an explanation of the correct answer. I would like to copy and past this information into an excel document and make it run like the online exam. For instance, someone would read question 1, select their answer (perhaps by typing the letter in a blank cell) and then have the excel sheet automatically grade it as right or wrong.

I am sorry if my question comes off as ignorant but I know I do not know much about excel, except for the fact that it has numerous functions that I am not taking advantage of. I am simply looking for the simplest way to accomplish my above goal, if it is even feasible.

Thank you for your time and any help you may be able to provide!

 

[AlphaFrog]

There are a variety of methods and tools in Excel you could use; formulas, checkboxes, radio buttons, and macros. Do a web search for something like Excel Questionnaire template or Excel Survey template and you will find several downloadable examples.

 

[mds1303]

Thank you, great idea!