Google Sheets 2: Fundamentals : Using Formulas and Functions

Where is the formula bar?

• A

• B

• C

• D

Which column and row references are updated when you copy the formula: =SUM($B5:D$15)?

• Column D and row 15

• Column B and row 5

• Column D and row 5

• Column B and row 15

What function should be entered into B7 to calculate the total budget?

• =SUM(B3-B6)

• =SUM(B3:B6)

• =AVERAGE(B3:B6)

• =CALCULATE(B3:B6)

Which of the following functions adds a range of cells and then divides by the number of cell entries?

• SUM

• MAX

• MIN

• AVERAGE

A logical expression is an expression that evaluates to _____________.

• a sum

• a whole number

• an average

• either True or False

In a spreadsheet all formulas must begin with what symbol?

• $

• #

• =

• !

What formula would you enter into B7 to calculate the total budget?

• =3B+4B+5B+6B

• =B3+B4+B5+B6

• =B3<>B6

• =B3<>B6

You want to copy a formula across a row. What method would be best for the job?

• Find and Replace

• Copy and Paste

• Autofill

• Cut and Paste

What are the operators in the formula?

• A

• B

• C

• D

Which formula uses relative cell references?

• =$A$10/100

• =F18+F19/2

• =$B$5+30

• =5*10+20