Team Fundraising Spreadsheet

Create a new spreadsheet in OpenOffice Calc. Below are the instructions for completing this activity:

1. Type TEAM FUNDRAISING DRIVE in cell A1. Merge cells A1:G1.
2. Type Week 1, Week 2, Week 3, Week 4, and TEAM TOTALS, respectively, in cells B3:F3. These are your column headings. Format them appropriately.
3. Think of four team names and type them in cells A4, A5, A6, and A7.
4. For each of the teams, provide an amount that they raised for each week. (Refer to example below). These MUST be different for each team!
5. Type WEEKLY TOTALS in cell A9 and type TOTAL AMOUNT RAISED in cell C11, merging cells C11 through E11. 
6. Type a formula in cell F4 that calculates the amount raised by each team. Use the fill handle to copy the formula.
7. Type a formula in cell B9 that calculates the amount raised by all teams during each week. Use the fill handle to copy the formula.
8. Type a formula in cell F11 that calculates the total amount raised by all teams.
9. Select cells A3:E7. Create a BAR CHART to display this data.
10. Give it the title FUNDRAISING BY TEAM. The X axis should be labeled as Amount Raised and the Y axis should be labeled as Team Name.
11. Add data labels to the chart and choose 'show value as number'

Save the spreadsheet as 'Team Fundraising' in your spreadsheets folder.

Activity provided by: http://www.sun.com/aboutsun/comm_invest/ogp/training/downloads/mod6_create_your_own.pdf