Google Sheets 2 Review

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 B and row 5

• Column D and row 5

• Column D and row 15

• Column B and row 15

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

• =AVERAGE(B3:B6)

• =SUM(B3:B6)

• =CALCULATE(B3:B6)

• =SUM(B3-B6)

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

• MAX

• AVERAGE

• SUM

• MIN

A logical expression is an expression that evaluates to _____________.

• a whole number

• a sum

• either True or False

• an average

In a spreadsheet all formulas must begin with what symbol?

• !

• =

• #

• $

Which of the following functions returns the smallest number from a range of cells?

• MAX

• MIN

• SUM

• AVERAGE

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

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

• =B3<>B6

• =B3:B6

• =B3+B4+B5+B6

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

• Cut and Paste

• Find and Replace

• Autofill

• Copy and Paste

What are the operators in the formula?

• A

• B

• C

• D