Employee Salary Description
S no. First namLast nam DOB SAL-JAN Sal-Feb Sal-Mar sub-total Avg Sal
4 HARI SINGH ### 3400 3400 3400 10200 3400
2 GOPAL VERMA ### 1700 2300 3200 7200 2400
3 JOSEPH PAUL ### 2000 1200 2100 5300 1767
1 RNM KUMAR ### 1500 1200 2300 5000 1667
5 RAJA RAM ### 1200 1200 1300 3700 1233
Numbers Round Round Up Round Down
1.033 1 2 1
2.04 2 3 2
2.8768 3 3 2
3.736773 4 4 3
1.3678 1 2 1
4.99737 5 5 4
Full Name
HARI SINGH
GOPAL VERMA
JOSEPH PAUL
RNM KUMAR
RAJA RAM
January Monday jan
February Tuesday feb
March Wednesdamar
April Thursday apr
May Friday may
June Saturday jun
July Sunday jul
August aug
September sep
October oct
November nov
December dec
jan
Name Gender Age Class House Unit Test 1 Unit Test 2 Final Test Email
Sudevi F 16 10 JAL 81 80 87 sudevi@mail.com
madhav M 16 7 JAL 86 92 89 madhav@mail.com
Champa F 15 8 JAL 81 78 88 champa@mail.com
Indu F 15 8 JAL 90 86 89 indu@mail.com
sudevi@mail.com
madhav@mail.com
champa@mail.com
indu@mail.com
Name Gender Age Class House Unit Test 1 Unit Test 2 Final Test
RNm M 16 10 AGNI 86 81 77
Keshav M 17 9 AGNI 87 89 96
Gopal M 14 8 AGNI 70 75 79
Email
rnm@mail.com
keshav@mail.com
gopal@mail.com
House Gender Sum of Final Test
JAL F 264
M 89
AGNI F 98
M 252
BHOOMI F 85
M 191
VAYU F 92
M 171
RNM SCHOOL DATA
Name Gender Age Class House Unit Test 1 Unit Test 2 Final Test
Abhimanyu M 16 10 BHOOMI 84 79 95
Arjun M 11 5 VAYU 82 83 91
Champa F 15 8 JAL 81 78 88
Gopal M 14 8 AGNI 70 75 79
Gopi M 16 10 BHOOMI 88 92 96
Hari M 14 10 VAYU 82 81 80
Indu F 15 8 JAL 90 86 89
Keshav M 17 9 AGNI 87 89 96
lalita F 12 10 VAYU 70 90 92
madhav M 16 7 JAL 86 92 89
RNm M 16 10 AGNI 86 81 77
Sudevi F 16 10 JAL 81 80 87
visakha F 16 10 BHOOMI 70 80 85
Vrinda F 14 8 AGNI 91 87 98
VLOOKUP PIVOT TABLE
Name Final Test
Abhimanyu 95
Arjun 91
Champa 88
Gopal 79
Gopi 96
Hari 80
Indu 89
Email
abhimanyu@mail.com
arjun@mail.com
champa@mail.com
gopal@mail.com
Gopi@mail.com
hari@mail.com
indu@mail.com
keshav@mail.com
lalita@mail.com
madhav@mail.com
rnm@mail.com
sudevi@mail.com
vishakha@mail.com
vrinda@mail.com
Name
Abhimanyu
Arjun
Champa
Gopal
Gopi
Hari
Indu
Keshav
lalita
madhav
RNm
Sudevi
visakha
Vrinda
GRADES
A
B
C NAME GRADES
Abhimanyu B
Arjun B
Champa B
Gopal B
Gopi B
Hari B
EMAIL NAMES
abhimanyu mail.com
arjun mail.com
champa mail.com
gopal mail.com
Gopi mail.com
hari mail.com
indu mail.com
keshav mail.com
lalita mail.com
madhav mail.com
rnm mail.com
sudevi mail.com
vishakha mail.com
vrinda mail.com
Name Final Test
Abhimanyu 99
Arjun 91
Champa 88
Gopal 79 Fi
Gopi 96 120
Hari 80
Indu 89 100
Keshav 96
lalita 92 80
madhav 89
60
RNm 77
Sudevi 87 40
visakha 85
Vrinda 98 20
0
l pi ri
yu ju
n pa pa Ha du
an Ar am Go Go In
hi
m Ch
Ab
Final Test
Final Test
l pi ri av vi
pa Ha du ita ha
v m
de kh
a da
Go Go In esh lal ad RN u sa r in
K m S vi V
