How can we help?

You can also find more resources in our Help Center.

Absolute cell reference

Does not change when copied or moved to a new cell.

Formula

The equation used to calculate values in a cell.

Manual calculation

Lets you determine when Excel calculates the formulas.

Mixed cell reference

Cell references that contain both relative and absolute references.

Operand

A constant (text or number) or cell reference used in a formula.

Operator

A symbol that indicates the type of calculation to perform on operands.

Order of evaluation

The sequence used to calculate the value of a formula.

Point-and-click method

Allows you to point and click each cell in a formula rather than typing

cell references.

cell references.

Relative cell reference

Adjusts to its new location when copied or moved.

Sum button

Makes adding long columns or rows of numbers simple to do.