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.