Module 5
What symbols is used in an absolute formula?
$
When following the order of operations, which calculation will the spreadsheet calculate first in this formula: 4+(15*2)-10/2?
(15*2)
Google Sheets is most similar to what Microsoft program?
Excel
A relative cell reference does NOT change when copied to another cell.
False
Google Sheets, like most G Suite apps, do not use an auto-save feature and must be saved manually.
False
You cannot limit people to submitting only one response in a Google Form.
False
You have to download special software to run Google Forms on your computer.
False
If you want an easier way to sort through you form responses, Google Forms allows you to see your form responses in:
Google Sheets
If you want each person to only take your survey once, which setting should you check?
Limit to 1 response
To begin seeing who has completed your form, what tab on Google Forms should be selected?
Responses
Which function would you use to add the values of 5 cells together?
Sum
A form can be used to create a quiz.
True
Cells are named based on where they intersect a row and column.
True
Functions and formulas can be inserted into the Google Sheet that your form responses are on.
True
In a Google Sheet, the equal sign for an equation comes before the formula.
True
The main purpose of Google Forms is to collect information.
True
When creating a formula using multiplication, you must use an asterisk (*) for the multiplication symbol, NOT an x.
True
If you want to add a formula that uses exponents, what symbol would you use to indicate an exponent?
^
To change your Google Form's color, you should click:
color palette icon
Formatting commands that can be added to a Google sheet include: Select all that apply.
date percentage signs dollar signs time
In Google Sheets, what is the default reference?
relative
What are the two difference cell references? Select all that apply.
relative absolute
Which of the following types of questions can be used when creating a question in a Google form? Select all that apply.
short answer checkboxes multiple choice long answer dropdown
To combine cells together, you would use:
the merge option