Google Sheets Formulas & Functions

Which formula is a simple formula?

• =C3+10-E3

• =E10/5+1

• =10-(A3-D13)

• =5+A1*B1

Using the correct order of operations, what does this formula equal? =5+3*2

• 15

• 20

• 11

• 10

A way to point to a cell location on the spreadsheet

• Row

• Column

• Cell Reference

• Count

The "order of operations" defines which parts of a complex formula are calculated first.

• TRUE

• FALSE

In the formula =10+C5, what part of the formula is the "10"?

• An operand

• An operator

Define the following operator: +

• Multiplication

• Addition

• Division

• Subtraction

In the formula =A3/B3, what part of the formula is the "/"?

• An operand

• An operator

Define the following operator: *

• Multiplication

• Addition

• Division

• Subtraction

Which of the following uses a FUNCTION to calculate the total value for cells B2 through B5?

• =B1++B5

• =13.5+6.08+7.53+45.1

• =SUM(B2:B5)

• =B2+B3+B4+B5

A cell reference in a formula allows you to point to another cell location.

• TRUE

• FALSE