Computer 6 MS Excel Expressions and Operators

The type of reference that does not adjust the cell addresses when formula is copied or moved to a new location.

• Formula

• Absolute cell reference

• Relative cell reference

• Expressions

An identifier that is used to represent the cell or range containing the values to be used in a formula.

• Formula

• Absolute cell reference

• Relative cell reference

• Cell reference

An equation that calculates data.

• Formula

• Absolute cell reference

• Relative cell reference

• Cell reference

The values or cell references to be calculated.

• operand

• operator

• expression

• formula

The symbol that represents the type of calculation.

• operand

• operator

• expression

• formula

The sequence in which operations are evaluated.

• operand

• order of precedence

• expression

• formula

A type of reference that adjusts the cell addresses based on a new location of the formula.

• Formula

• Absolute cell reference

• Relative cell reference

• Expressions

Solve the following:

• 15

• 26

• 21

• 25

Solve the following:

• 19

• 40

• 22

• 20

Solve the following:

• 46

• 31

• 21

• 23