Randomly Select Questions from a Bank in Google Forms

preview_player
Показать описание
Have a bank of questions and want to make multiple Google Forms Quizzes from that bank? Here's how!

Рекомендации по теме
Комментарии
Автор

How do I handle a multichoice question back?

clementobieromah
Автор

@5:05 If you're concerned about the questions changing after you start, you could use Copy, then Paste Values Only to make them permanent.

seanr.sullivan
Автор

Great video. My test bank has separate columns for question, answer 1, answer 2, 3, 4, and correct answer. How can I pull the random questions along with their corresponding answer choices and answer?

edmccann
Автор

=ARRAY_CONSTRAIN( SORT( FILTER(A2:A, A2:A<>" "), RANDARRAY( COUNTA(A2:A), 1), TRUE), 5, 1) NOT WORKING

Ram_Mandir