I am trying to prepare a quiz in EXCEL. One sheet contains approx 800 terms and their meaning. I want to generate the quiz where 20 definitions can be selected at random from the other sheet and the user is asked to enter its corresponding meaning. And at the end the score can be calculated and displayed to the user taking the quiz.
Bookmarks