StudyBrixFree worksheets, study guides and courses

Computer science · lesson 1 of 4

Formulas and cell references

An expression in a spreadsheet cell that calculates a result.

University8 practice questionsNotes + worked examples
Take the quizStudy guideRevision sheet

Learn the ideas

Prerequisites: Basic arithmetic and computer literacy.

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

Example 1

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

Example 2

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

8 questions

Decimals or fractions are accepted for numeric answers. Proofs and written responses use sample answers and require human marking. This is practice, not a protected examination.

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

Show answer and explanation

Formula

Formula is the matching concept in this lesson.

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

Show answer and explanation

Cell reference

Cell reference is the matching concept in this lesson.

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

Show answer and explanation

Relative reference

The scenario directly calls for Relative reference.

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

Show answer and explanation

Absolute reference

The intended concept is Absolute reference.

5 Which statement about Formula is most accurate?

Show answer and explanation

An expression in a spreadsheet cell that calculates a result.

The definition in the lesson notes gives the required condition.

6 Explain one important difference between Formula and Cell reference.

Sample answer and marking guidance

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.

7 Give a short example showing how Relative reference would be used in practice.

Sample answer and marking guidance

A valid example should demonstrate this idea: A reference that adjusts when a formula is copied.

Credit a relevant scenario that applies the concept rather than merely naming it.

8 Summarize why Absolute reference matters in the lesson “Formulas and cell references”.

Sample answer and marking guidance

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

Credit the core purpose, scope and any important limitation from the notes.

Further reading and review references

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