Excel 4

Which of these shows the type of calculation to be performed?

• Operator

• Operand

• Absolute cell reference

• Mixed cell reference

A constant or cell reference that is used in a formula is a:

• Operand

• Operator

• Relative cell reference

• Absolute cell reference

Which of these adjusts to its new location when copied or moved?

• Relative cell reference

• Operators

• Absolute cell reference

• Operands

Which of these does not change when copied or moved to a new cell?

• Absolute cell reference

• Relative cell reference

• Operator

• Operand

Which cell reference contains both relative and absolute references?

• Mixed

• Absolute

• Relative

The _____________________ lists how many of the selected cells contain numbers.

• Numerical Count

• Sum

• Operator

• Operand

The __________________ calculation lets you choose when Excel calculates the formulas.

• manual

• automatic

• Numerical Count

• Sum

The _________________ button makes it easy to add the numbers in columns or rows.

• Sum

• Plus

• Numerical Count

• Addition

The * symbol indicates which type of operation?

• Multiplication

• Division

• Subtraction

• Addition

Worksheet formulas have ____________ and operands.

• operators

• symbols

• operations

• sums