## Creating a Personal Water Usage Usage Spreadsheet in ClarisWorks

**Open ClarisWorks and choose Spreadsheet**

- In cells A1 - A7 enter each category of water use from your chart.
- In cells B1 - B7 enter your quantity numbers.
- In cell C1 calculate your total for flushing the toilet by typing
**
=4*B1** (the equals sign tells the spreadsheet to perform a calculation, the *
means to multiply)
- Use this formula pattern to calculate totals for the next six categories
- Now compute your total water use for 24 hours.
- In cell B8 type the word
**Total**
- In cell C8 type the following formula
** =SUM(C1..C7)**

This tells the spreadsheet to add all the numbers in cells C1 through C7 and display
the total water use for the 24 hours.

- Save your spreadsheet on your floppy as
**wateruse**.
- Designate which cells you want to print by clicking in cell A1 and dragging
to cell C8. Under the
**Options** menu choose **Select Print Range** and click
OK. Now go to the **File** menu and print one copy.

Return to Personal Usage Lab