Lesson 3 spreadsheets

What is the order of operations?

What symbol is used for multiplication in a formula?

To make an absolute reference you place a ___ in front of the column name, the row name, or both.

What symbol is used for addition in a formula?

... help you calculate information on a spreadsheet.

What symbol is used for division in a formula?

When a cell's data changes the calculations connected to it are updated automatically.

The only way to copy a formula into other cells is to use copy and paste

What symbol is used for subtraction in a formula?

When formulas are used the information updates ...

A formula is a sentence that uses mathematical operations.

A formula always starts with ...

An absolute reference references the same specific cell and should not change when you paste it into another cell.

When a formula uses more than one operator (+,-,*,/) you always ...

When a formula is written and the enter key is pressed the formula appears in the cell.

In formulas a cell name represents the data in a cell

To add a range of cells you select all the cells then click the SUM tool.