Excel

List of Students of 11th Standard Roll No

First Name MiddleInitial Last Name Boy / Girl

1 Puja 2 Shalini 3 Zakiya 4 Harshit 5 Aryan 6 Varun 7 Prachi 8 Amit 9 Suvida 10 Nihal

S U S A V J M N M P

Sethia Gangele Malek Jain Nair Pathak Thakkar Surana Arolkar Shah

Types of Criteria Operator Meaning > Greater than < Less than >= Greater then or equal to <= Less then or equal to ,= Equal to <> Not Equal to * Wild card character

Data → Validation → Text Length Data → Validation → List Data → Form ( Delete and Restore ) Data → Form → Criteria Data → Filter→ Custom Filter Data → Filter→ Advance Filter

G G G B B B G B G B

Stream Arts Commerce Commerce Science Science Science Arts Science Science Arts

% age In Roll No 10th Std. 74 82 56 74 62 89 80 67 79 45

First Name 1 Puja 5 Aryan 8 Amit

Last Name Sethia Nair Surana

Stream Arts Science Science

Science Commerce Arts

MARK SHEET OF STD 9TH ROLL NO NAME

MATHS

SCIENCE SST

ENGLISH HINDI

COMPUTER TOTAL

PERCENTAGE

1 RAMESH 2 PARESH 3 HEMANT 4 KAMAL 5 VIPUL 6 MAHESH 7 NIRMAL 8 MANOJ 9 ADITYA 10 KAMLESH

58 66 59 12 85 67 35 59 24 48

95 64 58 35 85 56 50 52 61 29

95 48 75 35 64 35 48 56 45 21

63 48 29 35 45 24 36 15 75 67

47 58 65 35 41 58 35 48 67 95

55 24 42 35 75 87 65 35 45 84

413 308 328 187 395 327 269 265 317 344

68.83 51.33 54.67 31.17 65.83 54.50 44.83 44.17 52.83 57.33

MAXIMUM MINIMUM

85 12

95 29

95 21

75 15

95 35

87 24

413 187

68.83 31.17

TOTAL =SUM( C10 :H10) PERCENTAGE AVEARGE(C10 = : H10) RESULT IF(J10>35,"PASS", = "FAIL") GRADE IF(J10>70,"DIST",IF(J10>60,"FIRST",IF(J10>50,"SECOND",IF(J10>=35,"THIRD",IF(J10<35,"FAIL",) = MAXIMUM MAX(C10:C18) = MINIMUM MIN(C10:C18) =

RESULT GARDE PASS PASS PASS FAIL PASS PASS PASS PASS PASS PASS

FIRST SECOND SECOND FAIL FIRST SECOND THIRD THIRD SECOND SECOND

HIRD",IF(J10<35,"FAIL",)))))