From the data given below
i) Fill the address in B3 using CONCATENATE Function.
ii) Change KAMARAJAR SALAI given in C2 as lower case in C3
iii) Change Chennai given in D2 as upper case in D3

	A	B	C	D	E
1	NAME	HOUSE NO.	STREET	PLACE	PINCODE
2	ANAND	123	KAMARAJAR SALAI	Chennai	600018

Sara Ltd., sells goods on credit basis. Their policy is to charge interest @ 2% p.a., for the period of default. From the following data, find out the amount to be collected from each customer. Assume 365 days in the year.

Customer	Sales	Date of Sales	Period of Credit (days)	Date of Settlement
M	25,000	10-04-2016	60	05-07-2016
N	14,000	28-05-2016	30	25-07-2016
P	28,000	14-07-2016	45	25-08-2016
R	54,000	03-08-2016	90	02-01-2017

Prepare payroll of the following employees.

	A	B
1	Name	Basic pay(Rs.)
2	Sasi	8000
3	Hari	10000
4	Karthi	6500
5	Viji	12000
6	Soni	9000

Additional information:
a. DA: 125% of basic pay
b. HRA: Rs.4,000 for employees basic pay greater than Rs.8,000, for others Rs.2,500.
c. PF Contribution: 12% of basic pay and DA
d. TDS: 10% for Gross pay greater than Rs.25,000, otherwise NIL.

The total sales volume (Product wise) of TECH Ltd for the year 2016-2017 is given below:

Product	Sales
Toothpaste	22000
Toothbrush	11000
Hair Oil	9000
Shampoo	13000
Toilet Soap	9500

a) Present the data in a column chart
b) Change the chart type to line chart.

Sales volume of Moon Ltd during 2017 is given below.
Draw Pie chart

	A	B	C	D	E	F	G
1	CITY	Chennai	Coimbatore	Madurai	Trichy	Tanjore	Tirunelveli
2	SALES (Rs in lakhs)	500	350	250	250	200	150