Final Quiz Section

If you enter a wrong formula, Sheets can automatically correct it based on previous formulas

When you want to combine cells, you would click...

In Sheets, a filter can help you...

An absolute reference can lock to column cells or row cells, but never both

Forms can be used to

This function will add a range of cells

Sorting will allow you to sort an entire sheet, or just a specific range

There are ___ types of questions in Forms

In Forms, this acts like a Page Break

What type of Forms response would be appropriate for a long answer?

The mathematical responses in Sheets are called

You cannot use an absolute reference if you intend to use the fill handle

After creating a form your responses are shown in a Google Doc

If you want to have cell data to appear on a second line below, you would use...

Sorting is done by this section

Cells running left to right are called

You can expect to see these in the response page of a Form

Google spreadsheets follows the order of operations

Cells references are relative by default

You can add images, but not video to a From

Merging cells allows text to move down to a second line.

The AVERAGE function will do this

This symbol is a caret, used for exponents

Once a result is created inside a relative reference, the result cannot change

Spreadsheet responses from Forms will be titled

This item is visible as a blue square on the bottom right of a cell

You can have multiple filters applied at one time

To create an absolute reference, use this symbol

Responses to Forms are first visible as

A question that has multiple statements with various predetermined responses above would use:

You can _________ a cell reference, or ___________ to add it to a formula.

A Cell Address in a formula is called it's

Data in a cell can also be found here

You use this symbol to start a formula

What is this Sheets icon?

When cell data that is used in a formula changes...

In Sheets, if a cell is not connected to others, it cannot be used inside of a formula

When notifications are turned on in Forms, you will get...

To create more questions to a form...

When you send someone a Form, you can allow them to view a summary of others' responses

There is no way to allow someone to edit their responses once they submit a form.

In Sheets, you can drag and drop rows/columns

Cells running up and down are called

The intersection of a Column and a Row is called

The order of operations is...

You can only ever respond once to a Form

You would see this icon when you want to resize a column or row

Rows can be inserted to the left or right of an existing one