Excel 1 Unit 2: Basic Formulas and Functions Quiz Review

Which formula would you enter to return the number 2?

• =AVERAGE(A2:B5)

• =SUM(A2:B5)

• =MAX(A2:B5)

• =MIN(A2:B5)

Which formula is a simple formula?

• =C3+10-E3

• =E10/5+1

• =10-(A3-D13)

• =5+A1*B1

Where is the Formula Bar?

• A

• B

• C

• D

• E

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

• True

• False

Which of these statements about cell references is NOT true?

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

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

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

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

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

• An operand

• An operator

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

• An operand

• An operator

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

• 15

• 10

• 20

• 11

Define the following operator: +

• Subtraction

• Division

• Addition

• Multiplication

Define the following operator: *

• Subtraction

• Division

• Multiplication

• Addition