The following worksheet shows the salary calculations for employees in the sales department of a company.

	A	B	C	D	E
1
2	SALARY CALCULATIONS
3	EMPLOYEES NAMES	MARITAL STATUS	BASIC SALARY	MONTHLY SALES	DEDUCTIONS
4	Barak M.O.	Married	27000	250000	8000
5	Njuguna S. M.	Single	23000	234000	3000
6	Odhiambo W. O.	Married	28000	170000	4500
7	Macharia R. M.	Married	17000	213000	7000
8	Wanjiku E. M.	Single	22000	234000	5200
9	Kioo J. M.	Single	14000	567000	3200
10	Boit T.	Married	18000	123000	5000
11

1. Open a new workbook and save it as QUESTION TWO. (1 Mark)
2. Enter the data above with the necessary format into the first worksheet of QUESTION TWO workbook and rename the worksheet as Salaries. (2 Marks)
3. Make the Main heading to be Bold, Arial and size 16. The contents of cells A3:E3 should be size 14. The original numeric data should have a KSH currency format.(4 Marks)
4. Calculate the commission for each employee if an employee is entitled to 4% commission on the monthly sales. (2 Marks)
5. Calculate the monthly relief, which is 5% of the basic pay for the married employees. (2 Marks)
6. Use an appropriate logical test to determine if an employee is entitled to the monthly relief. (3 Marks)
7. Calculate the net pay for each employee. (2 Marks)
8. On the second worksheet of the workbook, plot a column chart to compare the basic salaries and the net salaries of the employees. Rename this sheet as Chart. (4 Marks)