Scribd
Upload
81 views1 page

Clait Unit 4 Spreadsheets Exercise 2: Mar Should Be 150 Not 190

The document provides instructions for making changes and additions to a spreadsheet tracking monthly expenses over 3 months. It instructs the user to correct values in January and March, delete a row of data, copy formulas to calculate totals for each month and cost category, insert a new month of data, and add formulas to calculate overall totals. It concludes by asking the user to save and print the updated spreadsheet.

Uploaded by

Jelyn Okeke
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
81 views1 page

Clait Unit 4 Spreadsheets Exercise 2: Mar Should Be 150 Not 190

The document provides instructions for making changes and additions to a spreadsheet tracking monthly expenses over 3 months. It instructs the user to correct values in January and March, delete a row of data, copy formulas to calculate totals for each month and cost category, insert a new month of data, and add formulas to calculate overall totals. It concludes by asking the user to save and print the updated spreadsheet.

Uploaded by

Jelyn Okeke
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 1

CLAIT

Unit 4 Spreadsheets

Exercise 2

1. Make the following changes to the spreadsheet:

The Jan entry for Elec should have been 60 not 50. The Food cost for
Mar should be 150 not 190.

2. The Petrol costs should not have been included. Delete the row
containing Petrol data.

3. Replicate the formula used to calculate the Totals for Jan for the other
months.

4. Enter a formula to calculate the Total cost for Rent for the three
months shown.

5. Replicate the formula calculating the totals for the other costs for the
three mnths shown.

6. Insert a new column headed Feb after Jan and before Mar. Enter the
following information.

Rent 400
Elec 55
Food 200
Ins 20

7. Adjust the spreadsheet to show the Total for Feb.

8. Calculate the overall Total which should be shown I the Totals row
and in the Total column.

9. Save the spreadsheet as Expenses2 and print one copy.


1.

CLAIT Unit 4 1 of 1
Exercise 4.2

You might also like