Excel Intro- Unit 2 Review

Which of these statements about cell references is NOT true?

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

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

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

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

Clicking on a cell will show its contents in the Formula Bar.

• True

• False

Which formula is a complex formula?

• =5+A1*B1

• =D6/E10

• =10-(A3-D13)

• =C3+10+E3

Define the following operator: *

• Division

• Multiplication

• Addition

• Subtraction

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 operator

• An operand

Which formula is a simple formula?

• =E10/5+1

• =5+A1*B1

• =10-(A3-D13)

• =C3+10-E3

Using the correct order of operations, what does this formula equal? =4/(5-3)*2

• 2

• 4

• 1

• 3

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

• True

• False

In this formula, which calculation would be performed first? =12*27+(71-54)

• 12*27

• 27+(71-54)

• 71-54

• It is unknown.