Google Forms Guide: Everything You Need to Make Great Forms for Free
Essentially, you'll add questions as rows, and options about them as columns. pre-populates choices in multiple choice or checkbox questions from a table in a spreadsheet. Email results after review• How about making a fun quiz for the kids? Let's start out by making a quick contact form so you can see how easy it is to use. Microsoft Forms in Office 365 allows you to create a variety of forms for personal, business, and educational purposes. It can ask for a date and month and, optionally, the year and time as well. To add a question, click Add question. Click Submit at the end, and Google will give you a unique link to share that copy of the form with the answers pre-filled. On the top right menu you can change the form's color scheme, preview the form, use the Send button to share the form, and access other extra options, including installing add-ons for Forms. Instead, it's incredibly easy to use, right from your Google account. If you want to send your form to someone with a different email address ending:• They both perform similar primary functions with the exceptions listed above. In this chapter, let's take an in-depth look at Google Forms' features, hidden tools, and add-ons to help you make the forms you need in minutes. Type your formula in LaTeX format, or add a function to graph, then insert it as an image into your form. 72;font-weight:bold;color: 6E8A57;margin:0 auto;padding:2px. Multiple choice answers are a mainstay, but Google also allows users to craft forms that require text-based and linear scale answers. When you need to gather data for your spreadsheets, a form is your best friend. There are also options to collect their username their Google Apps email address or only allow one response which requires respondents to log into their Google account. Change how you release marks• Forms add-ons let you add extra features to your forms, get customized notifications, turn your form entires into documents, and more. This feature makes it simple if you need the forms for document verification. It may not be a necessary feature, but it does make it easier for mobile device and tablet users to access the form and respond. There's no add-on for that, but you can use a Google Apps Script to and add them to Google Drive. It also includes data validation to require users to select a specific number of options. Choose question type• Just click the last button the right toolbar to add a section below the current question. Or, you can create text files from form entries for individual copies of each record. This is how to edit some settings and start using your forms in MS Teams:• Also, in addition to the standard option to require responses, the grid lets you require a response per row and can also limit users to only one response per column. Your Google Forms Cheat Sheet With so many hidden features, you might want a quick way to reference your favorite Google Forms features. When you've finished marking, at the bottom, click Save. Your users will see the date options in your locale's date format, unless they're logged into their Google Account, so be sure to keep that in mind when creating forms. A Tour of Google Forms Google Forms started life as a Google Sheets feature in , two years after Sheets' original launch. You could, instead, move the questions out and then delete that section. That's a perfect way to start a form with logic jumps. Zapier can then start new projects, add tasks and events, and make sure everything's in place to get your work done. There's an entire library of add-ons tucked away in the Google Forms menu. Yes, it is possible to use Google Forms in Microsoft teams. Then,View the average time to complete the quiz Go with Google Forms if you want to:• Or perhaps you want to get feedback from your team on your form. With your data sorted automatically, you'll be able to get work done with your form even faster. You can change your Google Account locale along with your account language at. You can optionally add answer feedback both for correct and incorrect answers, with a link for respondents to view more info if you'd like. So those are the primary functions that both Google Forms and Microsoft Forms share. Click on New Form• Or, you can search Google Images for photos, including royalty free stock photo and images from LIFE that are licensed to use inside Google Drive. Or you can send the notifications to Slack, SMS, or any other communications tool you want. With Microsoft, you just need an active MS ID to share a link directly or via email. At the top right of the question, choose how many points the question is worth. Go with Microsoft Forms if you want to:• Microsoft Forms Both Google Forms and Microsoft Forms offer the same core functions, so it may be hard to choose between the two. If that's an issue, you can add a note to the beginning of your form to remind people to set their Google language from google. Change your form field names, and they're automatically updated in your spreadsheet. Video: Google Forms only supports YouTube videos, which you can add either through search or with a link. Fill in your question and answers. By default:• With that enabled, you'll see a new Answer Key button on the bottom left of each question. Save Form Entries in a Database or Spreadsheet of Your Choice For a more customizable way to save your form data, Zapier can route your form entries to multiple spreadsheet sheets in any spreadsheet or database app you want. Google added more features to Forms over time, then finally turned it into its own standalone app in. Be creative: Form sections and jumps let you turn your form into a , and they can be a great way to condense detailed surveys down into only the most important questions for each person. Just open the Forms menu and select Add Collaborators, then enter individual collaborators' email addresses. Forms are among the internet's most versatile tools. Google Forms always keeps a full copy of all your form data, so if you accidentally delete something from your spreadsheet, don't worry. Create an answer key• Each response can be added to unique documents based on form questions, or they each can be added to the same document. For cases like these, click the Get pre-filled link option in the Forms menu, then fill in the options you want on the form. Click Save• OneDrive for Business• It can watch for a number of responses, a date and time, or a set value in your results spreadsheet, and then will disable your form once that's hit. Click on the trash can button next to the choice to remove it• How to Make a Quiz Using Google Forms: 15 Steps with Pictures div. Select Make this a quiz, and then choose whether to show the results immediately after the form is submitted or later once you review the answers. Just click Print in your Forms menu, and Google Forms will make a ballot-style copy of your form that you can print or save as PDF. Either way, here's what you need to do in Google Forms. Date: Want to ask for a specific date or time, perhaps to schedule an event or log an activity? At the top right, enter how many points the response earned. Multiple Choice: The default field for new questions in a Google Form, multiple choice lets you list options and have users select one. Make sure to think through where people who shouldn't see those questions are sent, too, perhaps with alternate questions in a separate section. limits how many times your form can be answered. But which form is the right form for you? That's great for quick form results, but for more tools to analyze answers, you can link your form to a Google Sheets spreadsheet. Enter your feedback and click Save. The difference is how the built-in support works. Via web browser• Go to the Microsoft Forms website• Forms will then automatically select a background color that matches your photo. Build Add-ons with Google Apps Script Need to receive files in a Google Form? Partial points: enter the number of points that you want to award. Do you prefer Microsoft Forms or Google Forms? If your readers are in Japan, say, and your form questions are in English, the UI text like Required and Submit will be in Japanese while your questions are in English. Whether you need to make a simple poll or want a dynamic survey with customized questions for different response types, Google Forms has the essential tools you need. Also, you can create simple or in-depth online surveys, share them from a link, embed them on your website, or even right inside an e-mail. The Google Forms Chrome extension allows you to access the Google Forms service where you can create online forms and surveys. The floating toolbar on the right lets you add more form fields. With connections to thousands of apps, Zapier can save your form data to other apps, send you customized notifications, and put forms at the center of your workflows. Tick the boxes next to the people who you want to email. lets you check in or out items with a form, essentially by rearranging data from one category to another in a spreadsheet. By default, it'll save each answer in the Responses tab, showing summary graphs and lists of answers. Once respondents have filled out your paper forms, just type their answers into your Google Sheets spreadsheet to save them along with your other form entries. Click on Section to organize question sections For Choice Questions:• Or, if you want to add them to another list, you could use Zapier to remove them from one list and then add them to another. Tell us why in the comments section below. Click on the link icon and select Copy• Google also gives you more control over who sees the form with editing options about who has access or who can add collaborators. Name the Form• Sharing the form via email includes an extra option: including the form in the email. Want to get feedback with a form partly filled in? Short Answer: This field is perfect for asking for small bits of text: names, email addresses, values, and more. At the bottom left of the question, click Answer key. No points: click Mark incorrect. Perhaps a contact clicks a button on your site that says they dislike one product, so you want the survey form to reflect that automatically. No extra downloading required. Click Send emails and release. Zapier can add new contacts to your CRM, save a note with info about what they wrote in the form, and even update existing contacts to log every time they fill out one of your forms. But Google found a solution for that. Just make sure your form entries are being saved to a spreadsheet, then connect it to Zapier, and build the custom workflows you need to get work done directly from forms. Note: If you add your own photo as a header, Google will only saved the cropped version of it to Drive. With your form data in the spreadsheet, you can use to calculate values or to visualize your data. Both Google Forms and Microsoft Forms offer a variety of choices for quiz creation. You can switch question types at any time, though do note that your field settings and questions will reset if you switch from multiple choice, checkbox, or menu to any of the other question types. Do note that the date format will be shown in the default format for your location. You can also use the embed feature on web pages. Under 'Requires sign in', untick Restrict to [your domain] users. Google Forms includes 12 field types: 9 question types, along with text, photo, and video fields. Login with Microsoft 365 work credentials, school credentials, or MS account• You can drag-and-drop questions between sections, but you can't rearrange full sections. Length and regular expression are the only data validations available here, so only use it when you want detailed feedback or longer notes in the answer. You can use Branching or conditional logic in MS forms, but your choice in form types is limited to six options like Text and Multiple-choice answers. Open the copy of the Google Form• Or, if you're storing your form data in a Google Sheets spreadsheet, there's a wealth of to do more with your data, which we'll look at in chapter 6. Click the photo icon to select a photo or Google Doodle-style drawing from Google's library as your form's header photo. You can then have the form jump to another section based on the answer or have the answer options shuffled to prevent bias. It's not the most powerful or customizable form builder. Organize a question into multiple pages• Spreadsheet Support As mentioned above, both Microsoft and Google offer built-in support for their respective spreadsheet programs. Use share options like QR code, embed into OneNote• Just make a form, then click the form's menu and select Make a copy. Zapier can send you customized email notifications with filters that watch for the text you want. Most notably, both form suites work well within their own office ecosystems but not with others. Go to , then either choose a template or start a blank form. Stylized Forms Okay, so Microsoft may not have the best selection of templates in comparison to Google. One great thing about saving Google Forms entries to a Google Sheets spreadsheet: It's fast. Save the Google Form to Drive and create a copy• Optional: To edit question or answer options, click Edit question. By default, new forms come in purple, while template forms often include an image. Under the answer, click Add feedback. To open an add-on, just select it in the add-ons menu, manage its settings from its add-on pop-over, and it'll then run in the background automatically. You'll then get a new puzzle piece icon in Google Forms, with a menu that lists each of your add-ons. It's a great tool for managing inventory or shared items, or it could be used creatively to, say, approve tasks or do other jobs where you need to move items between two categories. Integrate Google Forms with MailChimp, Salesforce, Trello, and More Another way to do more with your forms is with Zapier integrations. Need to gather responses offline? One of Google Forms' best features is that you can share the core form with others to let them help you build and edit the form. You can even use multiple sections in a single form or add conditional logic to your Google forms. You can to print, hang beside your desk, or share with your colleagues to help you collaborate in Google Sheets more easily. Create Documents from Form Entries For more customized documents, template tools like WebMerge can take your form data, create PDF documents from templates, and save or send them wherever you want. Learn more about the entire Google Apps suite:• To award points for a group of answers:• There's no menu option to manage or remove add-ons; instead, just open the Add-ons pane again, find the add-on you want to remove, click the green Manage button, and then select Remove in its menu. Find out the pros and cons of both Google Forms and Microsoft Forms so that you can choose the right one for your needs. Checkboxes: Similar to multiple choice, this field lets you list answers and have users select as many as they want. Mark quizzes You can see automatic summaries for all quiz responses, including:• CaptainForm is a form plugin that features a variety of templates as well as a drag-and-drop editor. Or, select one of your photos from Google Drive or upload a new one and crop it to fit in as a form header. Note: You can change form questions and answer options at any time, but if you do, it won't change entries that have already been added to your spreadsheet. Store Form Responses in a Spreadsheet Once you've created the form, you don't need to do anything extra to store respondents' answers in Google Forms. Full points: click Mark correct. Or, if you want to reuse a section, just click the section's menu and select Duplicate section for another copy of those questions. Today you can make and manage forms at , with templates and quick access to all your forms in one place. Frequently missed questions• Whether you need a contact form or a checkout page, a survey or a student directory, a form is all you need to easily gather that information. Once your form is finished, be sure to check the form settings before sharing it with the world. Optional: To add a written or YouTube video explanation to an answer, click Add answer feedback. Grow Your Email Newsletter List Use your form to expand your marketing efforts and stay in touch with your fans. But Google makes it a little easier because the information is stored in the cloud. After you mark each response, save your changes. Inside your form settings, you'll find a Quizzes tab. Average, median and range of scores Mark individual responses If you collect email addresses, you can assign points and leave feedback on individual responses. Or maybe you have a form that needs to be filled out with similar info each week, and you don't want to re-type it. Google Forms is now a full-featured forms tool that comes free with your Google account. To save your changes, at the bottom, click Save. Can You Use Google Forms in Microsoft Teams? How Do You Use Microsoft Forms? The date field is the one you want to select. Marks will release immediately• So, it really depends on how intricate you plan on making your quizzes. With these tips and tricks, it just might be the handy form tool you've always needed. You cannot, however, save multiple forms' responses to a single sheet. But Google comes out a little ahead of Microsoft in this area with more choices in its range of question types. OneNoteOnline Keep in mind, though, that you do need valid 365 login credentials to access the Forms program. You could use it to sort all similar entries into different sheets automatically. That's where sections come in handy: They let you break your form up into chunks to answer one set of questions at a time. Whether you've added images or videos, your form entry will have the standard title and description, along with options to resize and show the video or image centered, left, or right aligned. Try out both and see which one works best for you. adds graphs and functions to forms. This copies your actual form options into the email, and if your recipient uses Gmail, they can fill out the form inside their Gmail inbox, click Submit, and send in their answer without ever seeing your real form. Find the question that you want to mark. Import data or export results using Excel• For MS users, that means having an active Office Suite open and downloading the spreadsheet to your system. Here are some popular integrations to get started: Get Notified When Your Form is Filled Out Want to get notified whenever your form is filled out or when specific entries are added to your form? It's a great way to, say, make a signup form where respondents can each select one day or an order form for limited quantity items. But you may overlook that with their variety of themes. CaptainForm Are you looking for a WordPress alternative? turns your Google Forms fields into JSON data to import into other form apps. We'll look at those in-depth in chapter 6. Google Forms offers several settings options. Select Share on the form copy• It doesn't include section jumps, however. If you choose the latter, your form will need to require respondents to sign in with their Google account. With the questions out of the way, let's pull them together and make a complete form with sections and logic to route users to the correct questions. Dropdown: Want all of the answer options in a menu? Graphs marked with correct answers• Another way to make an interactive form is with Google Forms' mode. Is Google Forms the Same as Microsoft Forms? Turn Form Entries Into Tasks and Projects Your team has stuff that needs done, and a form can be an integral part of your workflow when connected to your or. Disclaimer: Some pages on this site may include an affiliate link. And you can manage most of your form needs using this simple feature. But you do need a paid subscription to access the MS Suite programs in Microsoft 365. Spreadsheet Support Both Google Forms and Microsoft Forms offers support for their respective spreadsheet suite. to the spreadsheet, and you'll be able to see patterns in your form responses at a glance. They created Google Forms and Microsoft soon followed suit. adds your form results to the end of a Google Docs document instead of a spreadsheet. They also offer a free plan so you can take it on a test run first. Share to social media using link sharing• The same sharing features you'd expect in Google Docs and Sheets are included with Forms.。 。 。
6
:max_bytes(150000):strip_icc()/GoogleForms_quizanswerkey-5c02cf9dc9e77c0001cda808.jpg "google forms")
