From the course: Google Sheets: Advanced Topics
Join today to access over 24,700 courses taught by industry experts.
Populate data using a Google Form - Google Sheets Tutorial
From the course: Google Sheets: Advanced Topics
Populate data using a Google Form
Welcome to Module 4, Populate data using a Google Form. Google Forms are online surveys used to collect data and provide the opportunity for quick data analysis. Google Forms allow multiple question types apply branching logic, as well as the options to embed YouTube videos and images. In this module, we're going to explore how forms and sheets work together by connecting collected form data to a spreadsheet or by creating a form from an existing spreadsheet. To create a Google Form that connects a Google Sheet spreadsheet, open an existing spreadsheet, open the tools menu and click create a form. A Google Form will open in a new browser tab. The form will have the same name as the spreadsheet from where it was created, but it can be changed by clicking on the name and typing the new name. Google Form supports many different question types. For text based answers, there are the short answer and paragraph question types. For choice based questions, there are multiple choice, dropdown…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
