-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Create "Multiple Choice" Tests on Excel
- Thread starter crilly
- Start date
Here is a link to a test workbook that may get you going in the right direction.
Instruction on sheet1 and sheet3 holds the test taker names and chosen answers. (sheet2 not used)
Many columns on sheet 1 can be hidden. The 5 categories & 75 question is probably more than needed.
The questions and answers are just plain stuff with no real question or real answer. They show which cells the question comes from and the four answer choices has one designated as the correct answer.
The large data set off-sheet on sheet1 has a question column, four answer columns and a correct answer column for each category.
A formula in cell I4 does most of the work and the possible answers are posted with a macro in J4:J7. Use the mouse, click on, your choice for a correct answer.
Give it a go, may be of some use.
Howard
https://www.dropbox.com/s/6kwzs6xr0xo7urt/Question Answer Drop Box.xlsm?dl=0
Instruction on sheet1 and sheet3 holds the test taker names and chosen answers. (sheet2 not used)
Many columns on sheet 1 can be hidden. The 5 categories & 75 question is probably more than needed.
The questions and answers are just plain stuff with no real question or real answer. They show which cells the question comes from and the four answer choices has one designated as the correct answer.
The large data set off-sheet on sheet1 has a question column, four answer columns and a correct answer column for each category.
A formula in cell I4 does most of the work and the possible answers are posted with a macro in J4:J7. Use the mouse, click on, your choice for a correct answer.
Give it a go, may be of some use.
Howard
https://www.dropbox.com/s/6kwzs6xr0xo7urt/Question Answer Drop Box.xlsm?dl=0
Upvote
0
Excel Facts
Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
></oSimilar threads
- Question
