Module 1.2
Task 8 - Replication


A.M.D.G.

Sometimes we have formulae in rows or columns that are very similar. There is a better way to fill in theses formulae rather than typing each one individually.

  • Open Module 1.2
  • Enter the following information in a new worksheet
 
A
B
C
D
E
1
  Length Breadth Area of Rectangle   
2
4
 3
      
3
6
6
      
4
3
9
      
5
7
3
      
6
8
7
      
  • Enter a formula in cell C2 to calculate area
  • Move your cursor to the bottom right of this cell and, when the cursor changes to a black cross, click and drag to cell C6
  • Save your work

Answer the following questions in your jotter.

1. What is the formula for calculating the area of a rectangle?

2. What is the formula for calculating the area of a triangle?

3. What happens to a formula when it is replicated?

4. Try copying and pasting a formula, does the formula remain the same when pasted?