Creating a self test

I have a list of questions in one column and the answer to each question in the next column. I would like to be able to create a self test (hiding the column with the answer) and be able to retake the same questions in a different order. Is there way to randomize the rows?

Originally Posted by esalutillo

I have a list of questions in one column and the answer to each question in the next column. I would like to be able to create a self test (hiding the column with the answer) and be able to retake the same questions in a different order. Is there way to randomize the rows?

Hi do you have a test book?

Also you can put a helper col in and use this formula below and Drag down the col for each row. This formula will create a random number between 1 and 100 then you can sort by the helper col.

Please Login or Register  to view this content.