Study Hub

Study Guides

This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.

Back to Study HubBrowse Year 11 Computing Guides

Year 11 - Computing

Formulas in a spreadsheet model

Spreadsheets

Unit Summary

In this unit pupils will explore how to use spreadsheets to store and manipulate data. They will use common functions and extract data to create visual representations using charts. Pupils will use spreadsheets to track and calculate income, make predictions, and answer "what if…?" questions.

Lesson Summary

You will learn to use formulas to perform calculations in a spreadsheet model and replicate formulas across a range of cells.

Key Notes

  • Relative and absolute cell references are used in spreadsheet formulas to control how cell addresses change when copied.
  • A relative reference changes automatically when the formula is copied to another cell.
  • An absolute reference stays fixed on one cell, even when the formula is replicated.
  • Using the correct type of reference helps ensure formulas calculate correctly when using tools like the fill handle.

Vocabulary To Learn

  • replicate: to copy or repeat something
  • relative: a cell reference that changes when a formula is copied or replicated to another cell
  • absolute: a cell reference that remains constant no matter where it is copied or replicated

Common Mistakes To Avoid

  • The fill handle can only be used to replicate formulas.

3 Quick Questions (With Answers)

1. Describe the system or process from this lesson in clear steps.

Relative and absolute cell references are used in spreadsheet formulas to control how cell addresses change when copied. A relative reference changes automatically when the formula is copied to another cell.

2. Define this computing term and give one practical example. 'replicate'

to copy or repeat something. Add one real device or system example to prove understanding.

3. Correct this common computing misconception.

Mistake: The fill handle can only be used to replicate formulas. Correction: The fill handle can replicate formulas, text and numbers.

More Lessons In This Unit

Browse all guides in the Year 11 Computing guide library.