Here’s how:

1. Click the 3 dots in the top right corner.
2. Select “Get Pre-Filled Link.”
3. Enter the answers you’d like to pre fill.
4. Click Submit.
5. Copy the link. All done!

via Jake Miller

The CopyDown add-on automatically pulls a formula down to a each new form submission. No manual dragging necessary. This is useful when your Form & Sheet are part of a bigger system that triggers other actions in other add-ons (i.e., autoCrat, formMule) that require those formulas.

via Jake Miller

Use items or questions from previous #GoogleForms and insert them into a new or different #GoogleForm.

via Teacher's Teacher tweet

Excerpt from Eric Curts' blog:

The new version of Google Forms does let you view each response one at a time, which is a definite step forward (click “Responses” then click “Individual”) but it is still not an easy way to view all the responses at once in an easy to read format.

One of the best solutions to this problem is an add-on for Sheets called “Save as Doc”.

Once you have “Save as Doc” add-on installed you can use it on any spreadsheet.

• Start by selecting the rows and columns of data you wish to turn into a Google Doc.
• Simply click, hold down your mouse button, and drag to highlight the desired data in your Google Sheet.
• Now click “Add-ons” then “Save as Doc” then “Start”.
• This will open a panel on the right side of the Sheet.
• For “Save Doc file” type in a name for the new document that will hold the data.
• Check “Include Headings” if you would like the column headings to appear above each item in the Doc. This can be useful so you remember what question each answer goes with.
• If you chose to include headings, you can specify where the headings are found in the “Headings Location” drop down menu.
• You can also select the size for the headings in the Doc from “Heading 1” (large) to “Heading 5” (small).
• Check the box for “Add a pagebreak after each row” to start a new page in the Google Doc for each row in the spreadsheet. This will put all the answers from each person who filled out the form on a different page of the Doc.
• Finally click the “Save as Doc” button.
• When done you can click the “Open the Doc” link to view your new document.

This screen cast will demonstrate how to make a Google Form a quiz, then import the grades into Google Classroom.

via Kim Mattina

Sheetgo is an excellent add-on you should definitely install on your Google Sheets. It allows you to easily transform data between different spreadsheets in Google Sheets. You can also use it to create a centralized overview of your data by merging several sheets into a single sheet. You can even import data from Excel files you have in your Google Drive right into your Google Sheets.