Huskerseth
New Member
- Joined
- Jan 30, 2018
- Messages
- 1
I am trying to figure out the best way to create a multiple choice Quiz from excel that can be printed for students to fill out.
what i have is Sheet 1 is full of test questions in Column A (rows 1 to 100 and growing) in columns B,C,D and E are the answers for the question on that row. I can change lay out of sheet 1 if needed
i want to be able to randomly chose 25 questions from sheet 1 and the corresponding answers and display them on sheet 2 in the following format for ease of printing
1) Question Test
A) Answer 1
B) Answer 2
C) Answer 3
D) Answer 4
I also need it to create an answer key for the randomly generated questions, so i don't have to hunt through 100's of questions to score the quiz. the answer key can be either on sheet 3 or spaced far enough out on sheet 2 so they would not print with the quiz questions.
Thanks in advance for any help or Ideas on how to do this
what i have is Sheet 1 is full of test questions in Column A (rows 1 to 100 and growing) in columns B,C,D and E are the answers for the question on that row. I can change lay out of sheet 1 if needed
i want to be able to randomly chose 25 questions from sheet 1 and the corresponding answers and display them on sheet 2 in the following format for ease of printing
1) Question Test
A) Answer 1
B) Answer 2
C) Answer 3
D) Answer 4
I also need it to create an answer key for the randomly generated questions, so i don't have to hunt through 100's of questions to score the quiz. the answer key can be either on sheet 3 or spaced far enough out on sheet 2 so they would not print with the quiz questions.
Thanks in advance for any help or Ideas on how to do this
