Google Sheets Quiz - Basic Formulas and Functions

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

• True

• False

2. Which formula is a simple formula?

• =E10/5+1

• =5+A1*B1

• =C3+10-E3

• =10-(A3-D13)

3. What is the argument in this function? =AVERAGE(B11:H14)

• B11

• B11:H14

• H11

• AVERAGE

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

• An operator

• An operand

5. Which of these statements about cell references is NOT true?

• You can enter a cell references in a formula by typing in the reference.

• Cell references make it easy to use values from other cells in a formula

• You can enter a cell reference in a formula by clicking the cell location on the spreadsheet.

• Cell references can only be entered in a formula by using the Formula Bar

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

• An operator

• An operand

7. Define the following operator: +

• Subtraction

• Division

• Addition

• Multiplication

8. Define the following operator: *

• Multiplication

• Addition

• Division

• Subtraction

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

• True

• . False

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

• =11

• =20

• =15

• =10