Google Sheets: Build a Quiz & Design a From

Previously, we talked about form logic and how to divide your forms into sections in great detail, and wrote a few sentences about the 12 field types. This time we will discover the Quiz mode in addition to the other form creation methods we mentioned. We will also explain how to create an awesome design to your form by changing its appearance.

Then, we start with the quite exciting topic about linking your form to a spreadsheet, which opens the door to a bunch of possibilities. You will be able to store data and work together on the spreadsheet with your teammates. And at last, but not least, you will learn how to share your form and adjust the sharing settings before showing it to the world.

How to Build a Quiz

Let’s try the Quiz mode, which is another way to create an interactive form in Google Forms. First, go to your form settings and select the Quizzes tab. Click on “Make this a quiz”, and then you can choose between immediately showing the results after each submission or later, after you manually reviewed the answers.

With the latter option, your respondents will be required to sign in with their Gmail account before filling the form. The missed and correct answers can be shown with the option to show a value for each answer as well.

If you enable that, a new Answer Key button will appear on the bottom left. By clicking it, you can select the correct answer. You can add answer feedback to both correct and incorrect answers for each question and even add a link for people to find out more about the subject. Only drop-down, checkbox and multiple choice questions can be used as quizzes.

Designing Your Form

As you set up your form, you will arrive to the part where you need to customize its appearance. A Google form includes a header image or color, along with a lighter background color which emphasizes the form. Purple is the default color for every new form, and if you choose a template form, it often comes with an image.

On the top right, you can find the color palette icon, and once you click it, a 15 color set will appear. Those are all darker colors for the header, and each of them applies a paler, complimentary shade to the background.

If you click the photo icon, you can select a drawing from Google’s library or any other photo as the header photo of your form. Of course, you can also upload a brand new photo or select one from your Google Drive. The background color will be automatically selected by Google Forms according to the photo.

There are some animated GIFs as well in the database such as moving balls, burning candles and more. However, if you try to add them as a header, they will be displayed as a still image. If you choose one of your own photos as a header, only the cropped version will be saved to your Google Drive.

A Spreadsheet for Storing Form Responses

Once the form is ready, Google Forms will automatically store the answers given by your respondents. Each answer will be saved in the Responses tab with lists of answers and summary graphs. There is also an individual response view which shows the live form and the results for each user.

Therefore, you can always get the results quickly and effortlessly. To analyze your answers in great detail, you can simply link your form to a spreadsheet in Google Sheets and try a few useful tools. In the Responses tab, you can find a Sheets icon that allows you to create a new spreadsheet or select a previous one. You can do the same by opening the menu and clicking the Select Response Destination option.

Results from multiple forms can be stored, by saving the data from each one to a separate sheet within a single spreadsheet. However, the responses for multiple forms can’t be saved to a single sheet.

There is a great thing about using a Google Sheets spreadsheet to save your Google Forms entries: It’s really fast. Whenever you change a field name in your form, it will be changed instantly in the spreadsheet as well. On the other hand, all new entries will show up in your spreadsheet right after a user hits the Submit button.

Keep in mind that while the form question and answer options can be changed at any time, the previously stored entries will always stay the same.

Google Forms reliably keeps a copy of your complete form data, so even if you accidentally delete something, it’s quite easy to restore it to your spreadsheet. All you need to do is to unlink the particular form from your spreadsheet in the Form response settings, or select the Form > Unlink Form option in your spreadsheet. Once you’re done, simply reconnect it and Google Forms will import your data again to a new sheet.

Now you can start analyzing the given set of form data in your spreadsheet by using the formulas in Google Sheets for calculation and custom graphs for visualizing. You can use some conditional formatting rules too, which will let you format rows, columns or cells to change their background or text color if they meet certain conditions. With this feature, the patterns in your form responses can be identified in seconds.

Google Forms can notify you in email whenever your form is filled out by a respondent. You can be notified by Google Sheets as well, just select Tools > Notification Rules for the advanced options. There, you have the option to be emailed once a day with a summary of responses or any time a change was made to a form entry.

If you want more features, there are great Google Sheets add-ons available to send a variety of notifications, apply formulas to survey responses and so on. We will talk about those later in our following articles.

How to Share Your Form?

When your form is finished, the next step is to share it with people and start getting responses. Or maybe ask for a little feedback first from your team members on your form. In both cases, you should know exactly how to share your form in Google Forms.

Collaborate on Forms

In Google Forms, you can share your core form with people who can assist in editing and building your form. Forms has roughly the same sharing features as Google Sheets and Docs. Just open the menu and click Add Collaborators, then fill the fields with the email addresses of each individual. There is also a Change… link that can make your form public inside your organization or on the web.

If you want to make form templates, just create a form, go to the menu and click the Make a copy option. You can always share your original form, so anyone who gets the link can make an own copy. This is a straightforward way to create shared template forms for your team.

Sharing Settings in Google Forms

Before sharing your form with the world, don’t forget to check the form settings. The settings can be found by clicking the gear icon, and there you can attach a confirmation page to the form. It’s similar to the form description field, but instead of formatting you have support for links.

There is another option to choose between sharing the form publicly with a link or only inside your organization. You can either collect people’s Google Apps email address or simply limit the form to only one response. This will require them to log into their Gmail first.

However, you can also let users edit their responses, submit another one, or see a summary of responses. With Google, you can shuffle the question order or enable a progress bar to display the number of completed form sections.

There is one more important thing to mention: Language. The form’s interface will be shown to your recipients in the default language for their location. For example, if your readers are in Germany, and your questions are in English, then your questions will stay in English and the UI text like Submit and Required will be in German. Of course, you can always add a note to remind your respondents to change their Google language first.

Thanks for reading! Next time we will continue with the same topic about sharing forms and creating new ones by changing certain settings. We will mention a few useful add-ons that can make your work easier, and we will also dig into more advanced methods, like integrating Google Forms into applications, setting up notifications and so on.


David Cross

David is the chief editor at WebHostingMedia right from the beginning. He has a great passion for building and managing websites and creating helpful content. He is also interested in programming - currently learning python.