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