Formulas and functions

This section describes:

• Basic principles of entering formulas and functions.
• Order of operations in a formula.
• Reference cells and cell ranges.
• Recalculation of formulas.
• Automatic calculation of functions.
• Enter functions.
• Function wizard.
• Replace a formula with its result.
• Copy and paste formulas.
• Names in formulas and functions.
• Reference to data in another document.
• Structured references.
• Array formulas.