3. Replication

Formulae Continued

In the last exercise Cell L4 contains the function = SUM(G4 ... J4).
Cell L5 is to contain the function = SUM(G5 ... J5).

This is the same function only on a different row. Here, replication can be used, which means copying the original function (in L4) and pasting it to all other cells where the function is to be entered again. The spreadsheet will automatically change all row numbers to match the row that is being used.

This is a great time-saving feature of spreadsheets and is something that you should find yourself using a lot as you work through these exercises.

What you have to do!

About Formulae and Functions! Click to Go Larger Screen

1. Open your records.xls file saved from the last exercise.
   1. Watch Movie 3 and use the method of replication shown, to automatically fill in values in all the required empty cells
   2. Save your file.
2. Download the file bonus points.xls.
   
   
   
   
   1. Use the same principles of replication shown in the video and the functions you used in the last section to complete the spreadsheet.
   2. Save your file
3. Down load the file skating contest.xls and complete the file
   
   
   
   
   1. and complete the file.
   2. Save your file.

Mark off Exercise 3, 4 and 5 in your Progress Grids

What you should now be able to do!

• Explain the advantages of using replication to repeat formula and functions in terms of saving time and effort.

• Replicate or copy formula and functions from one cell to another.

Continue to Section 4: Formatting