Copying Cells in a Spreadsheet

 ICT Skills - NSW Board of Studies
  1. Use basic mathematical operations (+, -, *, /, ^) to construct simple formulae
  2. Fill cell contents using commands (Fill Down, Fill Right)
Exercise 6 – Walkathon
Skills you will need for this exercise:

Click on a skill listed above to view a demonstration.

Mr Corrigan decided to keep a tally of the amount of money that each year group brought in each day for the walkathon. He has asked you to set up a spreadsheet for each of the 4 weeks of the collection period. Follow these instructions to set up your spreadsheet.

  1. Enter the following data into a new spreadsheet taking care to enter all data in the correct cells.

  1. Save your file as Walkathon.

  2. Select the range of cells A5:A9. From the Edit menu select Fill/Series. The dialogue box indicates that you are filling with dates, so accept this by clicking OK.

  3. Select cells B4:C4. Use the Autofill handle to fill in the remaining year groups in cells D4:G4.

  4. Select cells B5:H10 and use the toolbar button to format theses cells to currency.

  5. In cell H5 enter the formula =B5+C5+D5+E5+F5+G5.

  6. Select cells H5:H9 and from the Edit menu select Fill/Down to copy the formula for all dates.

  7. Select cell H6. By looking at the formula bar of the spreadsheet, what is the formula that has been entered into this cell?

    ____________________________________
     Is the formula the same or different to the one you copied from cell H5?

    _____________________
    What do we call cell references that change when we copy them?

    ______________________________________

  8. Select cell B10 and enter the formula =B5+B6+B7+B8+B9

  9. Select cell B10:G10 and from the Edit Menu select Fill/ Right to copy the formula in B10 across to G10.

  10. Select cell E10. By looking at the formula bar of the spreadsheet, what is the formula that has been entered into this cell?

    ____________________________________
     Is the formula the same or different to the one you copied from cell H5?

    _____________________

  11. Use the S button on the toolbar to enter a grand total in cell H10. What is the grand total for Week 1.

    ______________________

  12. Format the spreadsheet as follows: cell A1 Size 16/Bold, cell D3 Bold, cells A4:H4 Bold/Italics, cell A10 Bold/Italics.

  13. Select cells A4:H10. Select the Border command from the Format/Cells menu to add a double line outline border and a single line internal grid to the spreadsheet.

  14. Select cells A1:H10 (that is everything you have done). Use the Copy button on the toolbar to copy this part of the spreadsheet. Now select cell A15 and use the Paste button on the toolbar to paste the copy there

  15. In this second copy change Week 1 to Week 2 and change the first date to 11/8/03. Select the range of cells A19:A23 and use Fill/Series to fix the other dates.

  16. Select cells B19:G23. Press Delete to remove the contents of these cells. (Note – do not delete the formulae) What do you notice happens to the totals when you delete these amounts?

    __________________________________________________________________

  17. Make up some new numbers to go into these cells for Week 2. What happens to the totals as you add new values?

    ___________________________________________________________________

  18. What is your grand total for Week 2? _____________________________________

  19. Add your name(s) to cell A26.

  20. Save your spreadsheet and print it. Cut out the spreadsheet and paste it in the box below