Sheets Review

Google spreadsheets follows the order of operations

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

Data in a cell can also be found here

The mathematical responses in Sheets are called

Sorting is done by this section

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

Cells references are relative by default

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

In Sheets, this type of formula involves one operator

In Sheets, a filter can help you...

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

The AVERAGE function will do this

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

The intersection of a Column and a Row is called

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

The order of operations is...

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

This symbol is a caret, used for exponents

Cells running up and down are called

You can have multiple filters applied at one time

You use this symbol to start a formula

In Sheets, you can drag and drop rows/columns

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

A Cell Address in a formula is called it's

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

Cells running left to right are called

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

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

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

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

To create an absolute reference, use this symbol

This function will add a range of cells

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