Question

A. Create a trend chart after filling data into the worksheet. (Population of India/State in Millions to be enter)

Year	Male(1)		Female (2)		Total(3)
	Literate	Illiterate	Literate	Illiterate	Literate	Illiterate
2001
2002
2003
2004
2005
2006
2007
2008

Note: Total Literate = Values of Male Literate + Values of Female Literate

Total Illiterate = Values of Male Illiterate + Values of Female Illiterate

B. Create a Pie chart to compare data from the above table for Total (column number 3).

C. Draw a trend chart for each male, female and total separately.

D. Draw a Column Chart for the above data for each (male, female and total) separately for Literate and Illiterate.

Answer 1

A.

Year	Male(1)		Female (2)		Total(3)
	Literate	Illiterate	Literate	Illiterate	Literate	Illiterate
2001	150	50	100	70	250	120
2002	155	48	105	67	260	115
2003	160	46	110	64	270	110
2004	165	44	115	61	280	105
2005	170	42	120	58	290	100
2006	175	40	125	55	300	95
2007	180	38	130	52	310	90
2008	185	36	135	49	320	85

B.

C.

D.