MICROSOFT EXCEL EXERCISE

INFOPARK ZONE
(INSTITUTE OF  COMLPETE INFORMATION TECHNOLOGY)
UNIT TEST - 1ST
MICROSOFT EXCEL-2007
Note : All Questions Attempt. Every Question 4 Marks
Q1.	BIRTH DATE	29-Apr-73	Q2.	HRS	MIN	SEC		Q3.	START	END	DURATION
	Years lived			4	35	52			7:00	18:30
	and the months			3	49	36			8:00	17:00
	and the days		TOTAL						7:30	17:45
										TOTAL
Q4	PATIENT	WARD	DEPT.	ADMISSION DATE	DISCHARGED DATE	NO. OF DAYS	ROOM RENT	DAYS FEES	TOTAL AMOUNT	Condition for
	KAJOL	SKIN	SPECIAL	1-Jan-99	10-Jan-99			1200		SPECIAL DEPT=150/DAY
	AJAY	EYES	GENERAL	1-Jan-99	5-Jan-99			2100		GENERAL DEPT=100/DAY
q5.	Name	Basic	Pf Exempt	Pf	Esi Exempt	Esi	Total		Name	Amount	Dup/Uni
	Anuj Gupta	2600	No		No				BRIJESH	7500
	Brijesh	7500	No		No				DEEPESH	10020
	condition for PF BASIC>=6500= 780,OTHERWISE 12.2% OF BASIC								GARIMA	6500
	condition for ESI BASIC>=10000= 175,OTHERWISE 1.83% OF BASIC								HRIDYA PARMAR	8500
INFOPARK ZONE
(INSTITUTE OF  COMLPETE INFORMATION TECHNOLOGY)
UNIT TEST - 1ST
MICROSOFT EXCEL-2007
Note : All Questions Attempt. Every Question 4 Marks
Q1.	BIRTH DATE	29-Apr-73	Q2.	HRS	MIN	SEC		Q3.	START	END	DURATION
	Years lived			4	35	52			7:00	18:30
	and the months			3	49	36			8:00	17:00
	and the days		TOTAL						7:30	17:45
										TOTAL
Q4	PATIENT	WARD	DEPT.	ADMISSION DATE	DISCHARGED DATE	NO. OF DAYS	ROOM RENT	DAYS FEES	TOTAL AMOUNT	Condition for
	KAJOL	SKIN	SPECIAL	1-Jan-99	10-Jan-99			1200		SPECIAL DEPT=150/DAY
	AJAY	EYES	GENERAL	1-Jan-99	5-Jan-99			2100		GENERAL DEPT=100/DAY
q5.	Name	Basic	Pf Exempt	Pf	Esi Exempt	Esi	Total		Name	Amount	Dup/Uni
	Anuj Gupta	2600	No		No				BRIJESH	7500
	Brijesh	7500	No		No				DEEPESH	10020
	condition for PF BASIC>=6500= 780,OTHERWISE 12.2% OF BASIC								GARIMA	6500
	condition for ESI BASIC>=10000= 175,OTHERWISE 1.83% OF BASIC								HRIDYA PARMAR	8500