Unit 1 Chapter 3: [Assessment]- Google Spreadsheets & Forms
If you would like to how your Form looks to others you click on the preview button that looks like an eye
True
you can decide when to stop collecting responses on a Google Form
True
What do you do to rename a spreadsheet
Click Untitled Spreadsheet and type a new name
Change your form's look and feel you click
Color Palette
In your spreadsheet, select the cells you want to _____, then use the menus and toolbar to change their formats.
Customize
Google Sheet is similar to microsoft
Excel
Google Sheets is most similar to what Microsoft program
Excel
Cells in a spreadsheet cannot be filled with color
False
Google Sheets, like most G Suite apps, do not use an auto save feature and must be saved manually
False
If you needed the first 8 rows of your spreadsheet to be bigger and taller than the other rows, you can only grab the line in-between the rows one at a time to change the height of each row seperately
False
You cannot limit people to submitting only one response in a Google Form
False
Which formatting tool can you use to make the first row of a spreadsheet "stay in place" while scrolling down through the other rows
Freeze
If you want an easier way to sort through your 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
What formatting tool would you use to make cell A1, B1, and C1 become one cell for this title?
Merge
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
Which function would you use to add the values of 5 cells together?
Sum
In Google Forms there are at least seven-question type selections to choose from
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
The main purpose of Google forms is to collect information
True
When creating a formula using multiplications, you must use an asterisk * for the multiplication symbol, you an X.
True
When sharing Google Forms with other people you are working with, they can make changes at the same time and you'll see their changes after they happen.
True
The place where the column and row intersect is called a _____
cell
What is a quick way to view people responses to your Form
click responses tab
To change your Google Form's color, you should click:
color palette icon
To combine cells together, you would use:
the merge option
To create a new form you do the following
to create a new form you do the following: In google Drive, click File > New > Google Forms
Using the PEMDAS rule, which part of this equation would the spreadsheet calculate first? =B3-150+(.80*3)
(.80*3)
Which of the following types of questions can be used when creating a question in a Google form
-Checkboxes -Long Answer -Multiple Choice -Dropdown -Short answer
What are ways that you can collect responses from a Google Form without a spreadsheet
-See individual responses as they come in -See a summary of all responses
What kind of sharing access can you five with Google Sheets
-View -Comment -Edit
Which of the following types of questions can be used when creating a question in a Google form>
-short answer -check boxes -drop down -multiple choice -long answer
Formatting commands that can be added to a Google sheet include:
-time -percentage signs -date -dollar signs
When following the order of operations, which calculation will the spreadsheet calculate first in this formals 4+(15*2)-20/2
15*2
The equation below has BOTH multiplication and division. Following the rule of PEMDAS, the spreadsheet will calculate _____ first. 10+8/2*3
8/2
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
When creating a formula using multiplication, you can use either an (x) or an asterisk (*) for the multiplication symbol
False
You cannot convert a Microsoft spreadsheet to a Google Sheet because they are formatted differently
False
You cannot limit people to submitting one response
False
You have to download special software to run Google Forms on your computer
False
The formula shown for calculating a 10% discount will be incorrect when the spreadsheet follows the rule of PEMDAS. What needs to be changed so that cells D3, D4, & D5 get added together BEFORE it is multiplied by .20
Add parentheses around the cells to be added. = (D3+D4+D5)*.10