Размер видео: 1280 X 720853 X 480640 X 360
Показать панель управления
Автовоспроизведение
Автоповтор
How do I handle a multichoice question back?
@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.
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?
you can use the match function
@@GalaxyTab-u5k How? Can you please paste a formula that would work?
@@GalaxyTab-u5k How do you do that?
How to do this can you please explain
=ARRAY_CONSTRAIN( SORT( FILTER(A2:A, A2:A" "), RANDARRAY( COUNTA(A2:A), 1), TRUE), 5, 1) NOT WORKING
You have a space between your " ", delete the space and it works just fine.
@@meridithberghauer1455 ya after doing so much I got that. Thnx by the way
I had to change commas (,) to (;) in orden for it to work
How do I handle a multichoice question back?
@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.
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?
you can use the match function
@@GalaxyTab-u5k How? Can you please paste a formula that would work?
@@GalaxyTab-u5k How do you do that?
@@GalaxyTab-u5k How do you do that?
How to do this can you please explain
=ARRAY_CONSTRAIN( SORT( FILTER(A2:A, A2:A" "), RANDARRAY( COUNTA(A2:A), 1), TRUE), 5, 1) NOT WORKING
You have a space between your " ", delete the space and it works just fine.
@@meridithberghauer1455 ya after doing so much I got that. Thnx by the way
I had to change commas (,) to (;) in orden for it to work