Excel create practice exam

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!

No not so much a copyright issue as a I am graduating from school and will be losing my ability to access the school's resources and this information so I want to make a copy of it so I can study it before my boards.

Thanks!