Mr. Corrigan decided to keep a tally of the amount of money that each class group brought in each day for the walkathon. He has asked you to set up a spreadsheet for each of the 2 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.

2. Save your file as Walkathon.

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

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

5. Select cells B5:H10 and use the toolbar button to format these cells to currency.

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

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

8. Select cell H6. By looking at the formula bar of the spreadsheet.

a) What is the formula that has been entered into this cell?

................................................................................................................

b) Is the formula the same or different from the one you copied from cell H5?

................................................................................................................

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

................................................................................................................

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

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

11. Select cell E10. By looking at the formula bar of the spreadsheet.

a) What is the formula that has been entered into this cell?

................................................................................................................

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

................................................................................................................

12. Use the Autosum ( ∑ ) button on the toolbar to enter a grand total in cell H10. What is the grand total for Week 1.

................................................................................................................

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

14. 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.

15. 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.

16. In this second copy change Week 1 to Week 2 and change the first date to 08/11/06. Select the range of cells A19:A23 and use Fill/Series from the Edit menu to fix the other dates.

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

................................................................................................................

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

................................................................................................................

19. What is your grand total for Week 2?

................................................................................................................

20. Add your name to cell A26.

21. Save your spreadsheet