Is it possible to convert MCQs (Multiple choice question) on excel into Word?
I have an excel file which has many MCQs with the options and the correct answer (each one of them is in separate column) and I would like to get them into Word arranged like in a real exam on paper (question and then each one of the answers is in a different row)
I have to say that I don't know how to use Excel (except to open and read obviously) while I know very well Word, PowerPoint and Outlook.
In this file we see (from left to right)
- A:something not important.
- B: the question
- C, D, E, F, G, are the options for the correct answer.
- H: is the correct answer.
- E:the year of exam which it was taken from it.
Basically, columns A and E are not important and I can give up on them.