| 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 |
|
|
