Google Forms is a free product to help you create surveys, quizzes and other information-gathering items. Jess Stratton shows you how to create a form and save the results to a Google Sheet.
- [Presenter] Google Forms can be used to create surveys,…collect feedback, plan events, get advice,…or even send quizzes out.…You first create the form in Google Drive…or from within a Google Sheet.…The forms' results are stored in the different tab…in that Google Sheet.…Google Forms are free to use for anybody…with your Google account.…Let's create a very simple form to get some feedback…from our hotel guests.…I have a new blank sheet open here.…The first thing I'm going to do is give it a title.…In the top right-hand corner I'm going to rename it…from Untitled Spreadsheet.…
Now that it has a name I'll click Insert on the top menu…and choose Form all the way near the bottom.…It's going to open up Google Forms…and we have many, many ways that we can decorate…and create this form.…I'm going to click inside where it says Form Description…underneath the title.…I can also change the form name itself.…For example, I'll take the word Results off of it…and call it Hotel Guest Feedback.…In the Form Description I can add some text…
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.