Make your own free website on Tripod.com

Exercise 1(Excel)

In this exercise, you will be required to use an Excel spreadsheet to answer the following questions:

 

1. The table below shows the quarterly expenditure of five people in a household.

 

Name

Jan '00 ()

Feb '00 ()

March '00 ()

Abdul

310.56

403.10

384.10

James

431.72

342.00

344.00

Samuel

600.00

299.18

402.17

Lydia

456.07

466.00

610.00

Tina

201.10

342.19

334.04

 

1.1 Load Excel application and enter the data on a worksheet as shown above.

 

1.2 Insert another column after March '00 and name it "Total" and calculate the Total Quarterly expenditure for each person in the household.

 

1.3 Assuming that their quarterly income is as follows:

Abdul

James

Samuel

Lydia

Tina

3,761

7,271

5,746

4,439

6,312

Calculate their quarterly disposable income by inserting another column after Total called "Disposable Income".

 

1.4 Determine James' Disposable income if his quarterly income was reduced by 10%.

 

1.5 Save the document under the name of Expenditure and Print.