Procedure
Pie chart
(i) Enter the data given in the table in a new spreadsheet.
(ii) Select the data range from A1 to G2.
(iii) Go to Insert menu and select Pie Chart (3D Type)
(iv) Right click pie chart and select ‘Add Data Labels’

Procedure
(a) Column chart
(i) Enter the data given in the table in a new spreadsheet.
(ii) Select the data range from A1 to B7.
(iii) Go to Insert menu and select Column Chart (3D)
(iv) Right click column chart and select ‘Add Data Labels’
(v) Choose layout tab under Chart tools.
(vi) Select Axis title and name them.

(b) Line Chart
(i) Select the data range from A1 to B7.
(ii) Go to Insert menu and select Line Chart (2D)
(iii) Right click chart and select ‘Add Data Labels’
(iv) Choose layout tab under Chart tools.
(v) Select Axis title and name them.

(i) Open a new spreadsheet in MS-EXCEL
(ii) Enter labels and values in the cells as given above
iii) To calculate DA in Cell C2
= B2*125%
iv) To calculate HRA in Cell D2
= IF(B2>8000,4000,2500)
v) To calculate Gross Pay in Cell E2
=SUM(B2:D2)
vi) To calculate PF in Cell F2
=(B2+C2)*12%
vii) To calculate TDS in Cell G2
=IF(E2>25000,E2*10%,0)
viii) To calculate Net Pay in Cell H2
=E2-(F2+G2)
Output

(i) Open a new spreadsheet in MS-Excel
(ii) Enter the table headings as given below in different cells
A1 Customer
B1 Sales (`)
C1 Date of sales
D1 Period of credit (days)
E1 Date of settlement
F1 Credit period availed (days)
G1 Days of default
H1 Interest
I1 Amount collected
(iii) Enter customer names in A2:A5
(iv) Enter sales figures in B2:B5
(v) Enter date of sales in C2:C5
(vi) Enter period of credits in D2:D5
(vii) Enter date of settlements in E2:E5
(viii) In the cell F2 enter the formula =E2-C2 to calculate the period of credit availed in days. (ix) In the cell G2 enter the formula
=IF(F2-D2>0,F2-D2,0) to calculate the default days. (IF condition is used to avoid negative values in the case of payment before due date)
(x) In the cell H2 enter the formula =ROUNDUP((B2*2%)*(G2/365),0) to calculate interest for the default days and to round it to the nearest rupee.
(xi) In the cell I2 enter the formula =B2+H2 to add the amount of Sales and Interest.
(xii) Select the range F2:I2 and copy these cells down to the last customer.

Procedure
i) To fill the address
a. Open a new spreadsheet in MS-Excel
b. Enter all given values as given in the question
c. Enter the formula in the cell B3 as
=CONCATENATE(A2,” “,B2,” “,C2,” “,D2,” “,E2)
ANAND 123 KAMARAJAR SALAI Chennai 600018
ii) To change KAMARAJAR SALAI given in C2 as lower case in C3
Enter the formula in the cell C3 as
=LOWER(C2)
kamarajar salai
iii) To change Chennai given in D2 as upper case in D3
Enter the formula in the cell D3 as
=UPPER(D2)
CHENNAI