MARKS SHEET
Sno Student Name Maths Science English History Geography Computer Total
1 Arjun 75 65 75 82 90 88 475
2 Priya 92 94 80 85 88 92 531
3 Rohit 60 80 85 40 76 70 411
4 Kavya 35 45 55 65 75 85 360
5 Rakesh 35 35 35 35 35 35 210
6 Sneha 74 77 76 80 83 84 474
7 Anil 81 84 88 83 85 87 508
8 Nisha 87 90 86 89 91 25 468
9 Suresh 95 96 84 90 93 94 552
10 Deepika 83 88 81 84 89 86 511
FORMULAS
TOTAL SUM(C2:H2)
AVERAGE AVERAGE(C2:H2)
GRADE IF(J2>=90,"O",IF(J2>=80,"A",IF(J2>=70,"B",IF(J2>=60,"C",IF(J2>=
RESULT IF(AND(C2>=35,D2>=35,E2>=35,F2>=35,G2>=3
GRADE/RESULTIF(AND(C3>=35, D3>=35, E3>=35, F3>=35, G3>=35, H3>=35),IF(J3>=90,"O",IF(J3>=80,"A",IF(J3>=70
EET
Average Grade Result GRADE/RESULT
79.166666667 B PASS B
88.5 A PASS A
68.5 C PASS C
60 C PASS C
35 P PASS P
79 B PASS B
84.666666667 A PASS A
78 B FAIL FAIL
92 O PASS O
85.166666667 A PASS A
FORMULAS
SUM(C2:H2)
AVERAGE(C2:H2)
>=70,"B",IF(J2>=60,"C",IF(J2>=50,"D",IF(J2>=40,"E",IF(J2>=35,"P","F")))))))
,D2>=35,E2>=35,F2>=35,G2>=35,H2>=35),"PASS","FAIL")
90,"O",IF(J3>=80,"A",IF(J3>=70,"B",IF(J3>=60,"C",IF(J3>=50,"D",IF(J3>=40,"E",IF(J3>=35,"P","F"))))))),"FAIL")
DATE NAME PLACE PRODUCT VALUE
2/4/2020 RAJESH GUNTUR KEYBOARDS 4500
2/4/2020 GANESH VIJAYAWADA PENDRIVES 3000
2/6/2020 SANKER ONGOLE KEYBOARDS 4000
2/7/2020 PRASAD PONNURU MOUSE 12000
3/13/2020 RAVI GUNTUR MOUSE 7500
3/15/2020 SANKER VIJAYAWADA BLUETOOTH 6000
3/15/2020 SANKER TENALI BLUETOOTH 3500
3/24/2020 PRASAD TENALI KEYBOARDS 8000
4/3/2020 RAJESH VIJAYAWADA PENDRIVES 11500
4/14/2020 RAVI PONNURU EX HD 9700
4/22/2020 RAJESH GUNTUR EX HD 16500
5/8/2020 PRASAD GUNTUR MOUSE 4200
5/9/2020 SANKER PONNURU EX HD 7500
5/15/2020 RAJESH TENALI BLUETOOTH 3600
5/16/2020 SANKER VIJAYAWADA MOUSE 7000
5/29/2020 RAVI PONNURU PENDRIVES 6000
6/4/2020 PRASAD VIJAYAWADA EX HD 5500
6/18/2020 RAJESH ONGOLE PENDRIVES 11500
7/7/2020 SANKER TENALI MOUSE 4700
8/19/2020 RAJESH ONGOLE KEYBOARDS 6300
8/23/2020 RAVI VIJAYAWADA KEYBOARDS 18000
9/2/2020 RAVI GUNTUR PENDRIVES 3600
9/11/2020 GANESH PONNURU EX HD 4700
10/10/2020 RAJESH TENALI PENDRIVES 6600
10/15/2020 SANKER VIJAYAWADA MOUSE 5800
11/4/2020 GANESH TENALI BLUETOOTH 9000
11/12/2020 RAJESH TENALI KEYBOARDS 7700
11/24/2020 RAVI ONGOLE PENDRIVES 6100
12/9/2020 RAVI GUNTUR MOUSE 14500
1/4/2021 PRASAD GUNTUR MOUSE 15400
2/5/2021 PRASAD PONNURU KEYBOARDS 12500
2/14/2021 GANESH GUNTUR KEYBOARDS 10400
2/15/2021 SANKER TENALI EX HD 9400
3/6/2021 GANESH VIJAYAWADA PENDRIVES 5500
3/20/2021 RAVI TENALI PENDRIVES 6500
Pin NumbeFirst Nam Last Name(Company Salary(LPA)COUNTRY Branch SECTION
241UAI000ADDALA SAI GOOGLE 300000 USA CSM 1
241UAI000KARTHIK AKKABATHAMAZON 600000 INDIA CSM 1 formula
241UAI000PURNA KI ALLANKI AMAZON 400000 INDIA CSM 1 SNO
241UAI000PAVANSAI ANAKAPALLGOOGLE 500000 INDIA CSM 1 1
241UAI000USHA BORRA GOOGLE 600000 INDIA CSM 1 2
241UAI001BOYA SUBBA MOAMAZON 500000 INDIA CSM 1 3
241UAI001DINESH SABOYINA GOOGLE 600000 INDIA CSM 1 4
241UAI001CHAPPA BHAVYA SRINFOSYS 500000 INDIA CSM 1 5
241UAI001BHARGAV CHENNADAINFOSYS 400000 INDIA CSM 1
241UAI001RAJESH CHERUKU AMAZON 600000 INDIA CSM 1
241UAI001SRI SAI PR CHINTAPALGOOGLE 500000 USA CSM 1 formula
241UAI001VINAY DADIMADUGOOGLE 600000 JAPAN CSM 1 SNO
241UAI002MOJESH DEVA INFOSYS 600000 INDIA CSM 1 1
241UAI002SUVARNA DOLLA INFOSYS 600000 INDIA CSM 1 2
241UAI002SONU LEVIDONDAPATGOOGLE 500000 USA CSM 1 3
241UAI002VENKATA KDOPPALAPGOOGLE 600000 USA CSM 1 4
241UAI002SANJAY DUNNA INFOSYS 600000 USA CSM 1 5
241UAI002HARI KRIS DURGASI GOOGLE 500000 INDIA CSM 1
241UAI002JASHODA GANCHI AMAZON 600000 INDIA CSM 1
241UAI002VENKATA RGANDIKOTINFOSYS 600000 INDIA CSM 1 formula
241UAI003GANGUMALL GANGUMAL GOOGLE 400000 USA CSM 1 SNO
241UAI003BHASKARAGARA INFOSYS 500000 USA CSM 1 1
241UAI003JITENDRA GEDDADA ACCENTUR 600000 USA CSM 1 2
241UAI003HEMA GEDDAM GOOGLE 600000 INDIA CSM 1 3
241UAI003SAI CHETHGODDEWLGOOGLE 600000 INDIA CSM 1 4
241UAI003SAHITH GOLLAPALLAMAZON 600000 INDIA CSM 1 5
241UAI003RAGHU PATGORREPATGOOGLE 500000 USA CSM 1
241UAI003SRIRAM GORRILA GOOGLE 600000 USA CSM 1
241UAI004NARASIMHMURTHY GAMAZON 600000 USA CSM 1 formula
241UAI004CHAKRI GUNDUBOIINFOSYS 600000 INDIA CSM 1 SNO
241UAI004MAHESH SA GUTTULA GOOGLE 600000 INDIA CSM 1 1
241UAI004YASWANTHGUTTULA GOOGLE 600000 INDIA CSM 1 2
241UAI004HARIDASU HARIDASUAMAZON 500000 JAPAN CSM 1 3
241UAI004HARSH SHRIVASTAGOOGLE 600000 INDIA CSM 1 4
241UAI004RAMAKRISINDUKURI ACCENTUR 500000 INDIA CSM 1 5
241UAI004SANDEEP INJE ACCENTUR 500000 INDIA CSM 1
241UAI004PRAVEEN GAGU AMAZON 600000 INDIA CSM 1
241UAI005SAGAR KL GOOGLE 600000 INDIA CSM 1
241UAI005ARAVEETI MAHENDRA GOOGLE 600000 INDIA CSM 1
241UAI005RAMA GANKAPAKAYAINFOSYS 500000 USA CSM 1
241UAI005JASHODHABORANA GOOGLE 600000 INDIA CSM 1
241UAI005RAEEZ SHAIKH AMAZON 600000 USA CSM 1
formula VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])
FIRST NAME LAST NAME
ADDALA
KARTHIK
PAVANSAI
BOYA
CHAPPA
formula VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])
PIN NUMBER Company Name
241UAI0023
241UAI0032
241UAI0046
241UAI0052
241UAI0017
formula VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])
LAST NAME Salary
CHERUKU
DADIMADUGULA
DOLLA
DOPPALAPUDI
GANCHI
formula VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])
FIRST NAME Country
JASHODHA
BHARGAV DHATH
SRI SAI PRAVEEN
RAEEZ
SAI CHETHANA PRIYA
