StudyBrixFree worksheets, study guides and courses

Computer science · University

Formulas and cell references

An expression in a spreadsheet cell that calculates a result.

Make a worksheet

Prerequisites

Basic arithmetic and computer literacy.

Study notes

Formula

An expression in a spreadsheet cell that calculates a result.

Cell reference

An address identifying a worksheet cell.

Relative reference

A reference that adjusts when a formula is copied.

Absolute reference

A reference fixed to a location when copied, often marked with dollar signs.

Worked examples

Which term best matches this description: An expression in a spreadsheet cell that calculates a result.

Formula is the matching concept in this lesson.

Formula

Which term best matches this description: An address identifying a worksheet cell.

Cell reference is the matching concept in this lesson.

Cell reference

Check your understanding

  1. Which concept would you apply first in a situation where a reference that adjusts when a formula is copied.

    1. Formula
    2. Cell reference
    3. Absolute reference
    4. Relative reference

  2. Name the concept described as: A reference fixed to a location when copied, often marked with dollar signs.

  3. Which statement about Formula is most accurate?

    1. An expression in a spreadsheet cell that calculates a result.
    2. An address identifying a worksheet cell.
    3. A reference that adjusts when a formula is copied.
    4. A reference fixed to a location when copied, often marked with dollar signs.

  4. Explain one important difference between Formula and Cell reference.

Answers and marking guidance

Answers and marking notes
  1. Relative reference

    The scenario directly calls for Relative reference.

  2. Absolute reference

    The intended concept is Absolute reference.

  3. An expression in a spreadsheet cell that calculates a result.

    The definition in the lesson notes gives the required condition.

  4. Formula: An expression in a spreadsheet cell that calculates a result. Cell reference: An address identifying a worksheet cell.

    Credit a clear distinction using both definitions and an appropriate example if supplied.

Further reading and review references

These are reference links, not copied exercises, institutional endorsement or proof of independent review.

AI-assisted preview; independent educational review required. Level labels describe prerequisites, not accreditation or official curriculum alignment.