Google Forms Cheat Sheet

Introduction to Google Forms

Google Forms is a free tool from Google that allows you to create surveys, quizzes, and forms with ease. It's part of the Google Workspace suite and integrates with other Google services like Sheets, Docs, and Drive. Whether you're collecting feedback, conducting surveys, creating quizzes, or registering event attendees, Google Forms provides a simple yet powerful solution.

Getting Started with Google Forms

To create a Google Form, follow these steps:

1. Go to forms.google.com
2. Sign in with your Google account
3. Click the "+ Blank" button to start a new form or choose a template
4. Give your form a title and description

Question Types

Google Forms offers various question types to suit different data collection needs:

• Short Answer: For brief text responses
• Paragraph: For longer text responses
• Multiple Choice: For selecting one option from a list
• Checkboxes: For selecting multiple options
• Dropdown: For selecting one option from a dropdown menu
• Linear Scale: For rating on a scale (e.g., 1-5)
• Multiple Choice Grid: For selecting one option per row in a grid
• Checkbox Grid: For selecting multiple options per row in a grid
• Date: For selecting a date (with optional time)
• Time: For selecting a time (duration or specific time)
• Image Upload: For respondents to upload images
• File Upload: For respondents to upload files (requires specific permissions)

Enhancing Your Questions

Customize your questions with these options:

• Required: Mark questions as mandatory to answer
• Description: Add additional instructions or context
• Response Validation: Set rules for acceptable answers
• Go to section based on answer: Create conditional branching

Form Settings

Customize your form settings by clicking the "Settings" tab at the top:

• Collect email addresses: Automatically record responders' emails
• Limit to 1 response: Prevent multiple submissions from the same person
• Edit after submit: Allow respondents to change their answers
• See summary charts and text responses: Decide if others can see results
• Shuffle question order: Randomize question order for each respondent
• Show progress bar: Display a progress bar at the top of the form
• Confirmation message: Customize what respondents see after submitting

Form Sections

Organize your form into sections to group related questions:

1. Click the last icon in the floating menu (looks like two rectangles) to add a section
2. Name each section to help guide respondents through the form
3. Add section descriptions to provide context
4. Create conditional branching based on section answers

Customizing Your Form's Appearance

Make your form visually appealing with these options:

• Click the paint palette icon at the top to customize colors and themes
• Choose from predefined themes or create your own
• Upload a header image (recommended size: 1600 x 400px)
• Select font style and color combinations
• Watch these changes apply in real-time

Adding Media to Your Form

Enhance your form with images and videos:

• Click the image icon in the question sidebar to add images
• Upload images from your computer, Google Drive, or use URLs
• Click the video icon to embed YouTube videos
• Add media to individual questions or the form description

Creating Quizzes

Turn your form into a quiz with automatic grading:

1. Go to the "Settings" tab
2. Click "Make this a quiz"
3. For each question, click "Answer key" to specify correct answers and point values
4. Set the release options for feedback: immediately after submission, at a specific date, or after manual review
5. Customize feedback for correct and incorrect answers

Sharing Your Form

Once your form is ready, share it with your audience:

• Click the "Send" button in the upper right corner
• Choose from these sharing options:
  • Email link directly to recipients
  • Get a link to share
  • Embed HTML for websites
  • Share via social media (Facebook, Twitter)
• Shorten the URL for easier sharing

Collaboration

Work together with others on form creation:

1. Click the "Add collaborators" option at the top right
2. Add collaborators by email or generating a shareable link
3. Choose permission levels: Viewer, Commenter, or Editor
4. Editors can make changes to the form
5. Viewers can only see and copy the form

Analyzing Responses

Review and analyze the data collected:

• Click the "Responses" tab to view all submissions
• See summary charts and graphs for quick insights
• View individual responses in detail
• Calculate totals and percentages
• Filter responses by question answers

Managing Your Responses

Organize and process your form responses:

• Click the green Sheets icon to link form to a Google Sheet
• Choose spreadsheet settings:
  • Create a new spreadsheet
  • Add to an existing spreadsheet
• Download responses as CSV file
• Print responses for offline use
• Delete individual responses or all responses

Advanced Features

Take your forms to the next level with these advanced features:

Response Validation

Ensure respondents provide information in the correct format:

• Set validation rules for short answer, paragraph, or numerical questions
• Choose from preset validations like email, URL, number
• Create custom validation with regular expressions
• Customize error messages when validation fails

Conditional Logic

Show different questions based on previous answers:

• Use "Go to section based on answer" in Multiple Choice questions
• Create branching paths through your form
• Skip irrelevant sections for different types of respondents
• Create personalized form experiences

Import Questions

Reuse questions from previous forms:

• Click the "Import questions" button in the floating menu
• Browse your forms and select questions to import
• Edit imported questions as needed
• Save time on form creation

Keyboard Shortcuts

Speed up your form creation process with these keyboard shortcuts (Windows/Linux):

Shortcut	Action
Ctrl + Enter	Go to next question
Ctrl + K	Add a link
Ctrl + B	Bold text
Ctrl + I	Italicize text
Ctrl + U	Underline text
Tab	Move to next question
Shift + Tab	Move to previous question

Useful Add-ons

Extend Google Forms functionality with these popular add-ons:

• Form Notifications: Get email notifications for form submissions
• Choice Eliminator: Remove options after they've been selected
• Form Ranger: Populate multiple choice options from a spreadsheet
• Yet Another Mail Merge: Send personalized emails to respondents
• Timer: Add a countdown timer to your form
• Limit 1 Response: Enhances Google's built-in one-response limit feature
• Form Publisher: Automatically generate documents from form responses
• formLimiter: Set limits on the number of responses or date/time windows

Best Practices for Google Forms

Follow these guidelines to create effective forms:

• Keep it short and focused to improve completion rates
• Use clear, concise language for questions
• Organize questions logically in relevant sections
• Use appropriate question types for the data you need
• Test your form before widespread distribution
• Consider mobile responsiveness when designing
• Use validation to ensure quality data
• Provide clear instructions where needed
• Review the visual design for readability
• Prepare your data analysis plan before collecting responses

Troubleshooting Common Issues

Solve these frequent problems you might encounter:

Form Not Receiving Responses

• Check that the form is not in "Not accepting responses" mode
• Verify the sharing link is working properly
• Confirm email recipients are receiving the form (check spam folders)
• Test the form yourself using a different account or incognito window

Limit One Response Not Working

• Remember that "Limit to 1 response" requires users to be logged into a Google account
• Users with multiple Google accounts can submit once per account
• Private/incognito mode may allow multiple submissions
• Consider using email collection if you need stricter accountability

Issues with Quizzes Grading

• Verify that all questions have answer keys set
• Check that point values are assigned for each question
• Ensure your form is properly set as a quiz in settings
• Review validation settings that might affect answer recognition

Summary

Google Forms is a versatile tool that can handle a wide range of data collection needs, from simple surveys to complex assessments. With its intuitive interface, integration with other Google services, and customizable options, it provides an excellent solution for individuals and organizations alike. By mastering the features outlined in this cheat sheet, you'll be able to create professional, effective forms that gather the information you need efficiently.