Lesson 15 Creating Simple Formulas

Google Sheets uses mathematical expressions called ___ to perform calculations.

What is the symbol used for multiplication in Google Sheets formulas?

• *

• /

• +

• -

In Google Sheets, all formulas must begin with which symbol?

• =

• +

• -

• *

Using a cell's address in a formula is known as using a ___ reference.

Which of the following is NOT a standard operator in Google Sheets?

• %

• ^

• *

• /

To create a formula, you must first select the cell that will display the ___ value.

What happens when you change a value in a referenced cell in Google Sheets?

• The formula automatically recalculates.

• The formula remains the same.

• The cell address changes.

• The formula is deleted.