Copying a Formula or Function

Many cells in a spreadsheet can have the same formula as the cell above it (with only the row numbers changing). In this case, a technique known as replication can be used to quickly put a formula into many cells at the same time.

To Do

11.View the movie file Replication.

b. Download the file swimming times and complete the exercise using the technique shown in the video.

Remember to tick off your progress grids.

Continue to Charting