Make your own free website on Tripod.com

1. Load up the spreadsheet program and use your own name as the title at the top of the spreadsheet.

2. Enter the headings: JAN, FEB, MARCH, APRIL, MAY, JUNE across the top.

3. Enter the headings: WAGES, RENT, RATES, HEAT, SUNDRIES, TOTALS as the row titles down the side.

4. Enter the following data, one figure for each row:

For January: 320, 40, 80, 40, 50

For February: 340, 40, 80, 40, 80

For March: 340, 40, 80, 30, 60

For April: 350, 40, 80, 20, 40

5. Incorrect information has been collected on the costs of sundries,which should be 60 in February and and 50 in April. Adjust the data accordingly.

6. Copy the data in the February column to the May column and the January data into the June data.

7. Generate the total costs for each month, using a summation formula.

8. Save the data for the spreadsheet.

9. Increase all column widths by 2 characters.

10. Add a row at the end of the spreadsheet, call it SALES and, starting at the top, enter data:

20000, 30000, 30000, 40000, 5000, 50000

11. Print out your spreadsheet.

12. Quit the system.