1. Introduction

Although you are probably very familiar with writing and copying formulae within a spreadsheet, you may not be so familiar with the terminology related to copying or replicating formulae and functions.

You need to completely understand and be able to explain, with examples, the differences between absolute and relative cell references and replication.

Read the notes on the following pages. They may seem long, but they take you through these concepts in a clear, step-by-step approach.

There are also exam hints at the bottom of the pages.