Advanced Features

Using Dropdown Menus

You can create dropdown menus for any boxes in a TableQuiz by using Google Sheet's "Data Validation" Feature. To use this feature, make sure you follow these steps before clicking the "Create Quiz" button.

  1. Open the Options sheet in your TableQuiz Key. Here, you can enter all of your drop-down items. In the example to the right, we added the options 1st, 2nd, and 3rd.
  2. Next, go back to the Quiz sheet and highlight the cells that you would like to contain drop down menus. Then click data => data validation. Make sure that show dropdown list in cell is checked and also check reject input.
  3. Click the tiny grid under "Criteria:" that says Select Data Range when you mouse over it. Then, go to your options sheet and select each answer that you want as an option (in this case, 1st, 2nd, and 3rd). Click okay once you have made your selection. You don't need to make any other changes, so click save.
  4. Return to the Quiz sheet. You should now have working dropdown menus for each blank that you had selected. Once you create your quiz file, these dropdown menus will stay for your students.