NAME PHYSICS CHEMISTRY MATHS CS ENGLISH

NRITEV 9 3 9 66 54
VASANT 63 30 42 46 90
ABHIMANYU 61 82 40 82 58
ANAMIKA 52 28 84 16 60
RAHUL 25 36 73 20 67
RITIKA 61 69 11 51 69
TOTAL PERCENTAGE STATUS
NAMES AGE ELIGIBILITY
Nritesh Singh 26
Tripti Suri 21
Lavanya Gupta 20
Krishka Pandey 28
Soni Dubey 11
Kiara Doda 21
Dinesh Keshwana 11
Mayank Yadav 26
Aman Chauhan 29
Ritvik Verne 21
Nakul Chattopad 14
Abhishek Kapoor 27
Sunny Pathak 24
Vikrant Gautam 13
Sidhharth Suri 25
Wari Sem Doda 29
Indir Turi Chand 19
Chandni Rawat 24
SALES HEAD TARGET target
Abhishek Kapoor 40000
Sunny Pathak 49999
Vikrant Gautam 81715
Sidhharth Suri 96064
Chandni Rawat 67689
Aman Rastogy 100500
Nishita Sharma 93536
Samiksha Kohli 62324
NAMES sales even/odd
Abhishek Kapoor 46
Sunny Pathak 29
Vikrant Gautam 54
Sidhharth Suri 52
Chandni Rawat 35
Aman Rastogy 59
Nishita Sharma 44
Samiksha Kohli 66
 or function is used when options are available
adhar card 1 only one condition
bank account--> OR
pan card 1 atleast one condition should be true

18+ y both condition necessary

voting--> AND
votercard y all conditions should be true
And function is used when all conditions are necessary
 NAME SILVER GOLD DIAMOND TOTAL SALES COMISSON
NEHA 34000 34000 20000
MAHESH 81207 55571 63680
ROHIT 86712 53362 91105
RITIK 61759 56186 59568
ROSHAN 47179 66913 80573
NINA 72845 67044 56326
TEENA 45121 68871 86959
ROSHAN 85677 69403 82540
XXZX
**** Assign Remarks

Student Letter Grade Remarks

Abhishek Kapoor B
Sunny Pathak B
Vikrant Gautam E
Sidhharth Suri Nomnom B
Chandni Rawat D
Aman Rastogy D
Nishita Sharma C
Samiksha Kohli C
Abhishek Kapoor A
Sunny Pathak D
Vikrant Gautam A
Sidhharth Suri Nomnom B
Chandni Rawat D
Aman Rastogy B
Nishita Sharma B
Samiksha Kohli E
Abhishek Kapoor B
Sunny Pathak D
Vikrant Gautam D
Sidhharth Suri Nomnom C
Chandni Rawat C
Aman Rastogy A
Nishita Sharma D
Samiksha Kohli A
Abhishek Kapoor B
Sunny Pathak D
Vikrant Gautam B
Sidhharth Suri Nomnom B
Chandni Rawat E
Aman Rastogy B
Nishita Sharma D
Samiksha Kohli D
Letter
Grade Remarks
B Good IF(C4=$H$4,$I$4,IF(C4=$H$5,$I$5,IF(
E Failed
D Poor
C Acceptable
A Excellent
$4,$I$4,IF(C4=$H$5,$I$5,IF(C4=$H$6,$I$6,IF(C4=$H$7,$I$7,IF(C4=$H$8,$I$8)))))
Roll NoStudent Name Physics Chemistry MathematicsGrand Total
1 Amarjeet Singh 78 99 74
2 Sachin Kumar Sharma 32 52 66
3 Mohit Malik 92 87 76
4 Deepak Sharma 38 31 47
5 Kratika Bhatnagar 67 72 50
6 Gaurav Khanna 31 27 33
7 Asif Khan 56 65 69
8 Ajaj Kumar Rana 99 98 93
9 Aakash Bhutani 83 92 80
10 Vivek Pant 53 50 55

REPORT SHEET
1 Number of Students
1 Class Overall Grade
1 Highest Marks in Chemistry
1 Lowest Marks in Physics
1 3rd Highest Marks in Mathemat
1 2nd Lowest Marks in Physics
Top Scorer Name
Bottom Scorer Name
1 Number of Student Failed in P
1 3rd Highest Scorer in Physics
 Percentage status Grade

GRADE CRITERIA
32 Fail
44 Third Division
59 Second Division
79 First Division
90 Distinction
100 Outstanding

GRADE CRITERIA
91-100 Outstanding
81-90 Distinction
61-80 First Division
44-60 Second Division
33-44 Third Division
0-32 Fail

Note: All marks are out of 100

Third Division
Second Division
First Division
Distinction
Outstanding
 Country Capital Status Correct Situation
Thailand Bangkok Country Capital If Capital is Matching with Country th
India Lucknow Thailand Bangkok
USA Malaysia India Delhi
Thailand chicago USA New York
India Kolkata
USA New York
Thailand Hong Kong
India Delhi
USA Germany
is Matching with Country then Status should be Correct Else Wrong
 Driver's Number
Date Item TOTAL SALES
name of items
1/1/2024 John May TV 25 ITEM PRICE
1/2/2024 Peter Whitwashing machine 30 TV 25000
1/2/2024 Carl Nowakwashing machine 15 washing m 15000
1/2/2024 Peter WhitTV 32 refrigerato 28000
1/2/2024 George Ra refrigerator 25 microwave 15000
1/2/2024 Carl Nowakwashing machine 18
1/2/2024 John May refrigerator 15
1/2/2024 Carl Nowakrefrigerator 25
1/2/2024 Peter WhitTV 30
1/2/2024 George Ra refrigerator 15
1/2/2024 Mertl Pavemicrowave 25
1/2/2024 John May washing machine 14
1/2/2024 John May washing machine 25
1/2/2024 Carl NowakTV 30
1/2/2024 George Ra microwave 15
1/2/2024 Peter WhitTV 15
1/2/2024 John May microwave 25
1/2/2024 John May TV 30
1/2/2024 George Ra washing machine 13
1/2/2024 Peter Whitrefrigerator 25
1/2/2024 Carl Nowakmicrowave 30
1/2/2024 Peter Whitwashing machine 15
1/2/2024 John May microwave 25
1/2/2024 George Ra washing machine 34
Names Subject Grand Total
Marks Scored Questions Answers
Abhijit Maths 250 225 What are the Average marks in Hindi
Abhijit English 250 239 What are the Total marks of Amey
Abhijit Hindi 250 232 How many subjects does Dev appear
Abhijit Science 250 225 What is the total character in Amar
Abhijit Accounts 250 231
Abhir Maths 250 231 Name Total Marks Division
Abhir English 250 236 Abhijit
Abhir Hindi 250 235 Amey
Abhir Science 250 195 Amit
Abhir Accounts 250 237 Abhir
Abhya Maths 250 235 Amar
Abhya Hindi 250 245
Abhya Science 250 227 Total Mar Division
Abish Maths 250 237 0-750 A
Abish English 250 233 751-1000 B
Abish Hindi 250 235 1001-1250 C
Abish Science 250 229
Abish Accounts 250 237
Amar Maths 250 233
Amar English 250 235
Amar Hindi 250 240
Amar Science 250 225
Amar Accounts 250 239
Amey Maths 250 227
Amey English 250 238
Amey Hindi 250 231
Amit Maths 250 229
Amit English 250 237
Amit Hindi 250 230
Amit Science 250 205
Amit Accounts 250 235
Dev Accounts 250 238
Raja English 250 234
Rajiv Science 250 215
Vikas Accounts 250 233
Roll Number Student Name Score Rank
151507 Julia Putin 65
167508 Michael Hicks 90
184782 Anna Newhart 74
199210 John Bradshaw 81
217184 Andy Richards 36
254223 Stephen Bell 53
265147 John Jennings 33
265791 Gloria Silverstone 60
283505 Jane Anderson 99
334673 Elizabeth Diamond 97
353809 Dan Armstrong 75
366796 Frank Lee 89
380729 Jessica Sagan 88
405608 Charles Davis 95
466104 Margaret Streep 61
491600 Chuck West 100
535974 Lucille Ashe 32
565143 Meryl Simpson 98
574587 Howard Simpson 51
695118 Alfred Hawking 55
723867 Julia Carrey 34
763457 Julie Spears 43
920259 Marilyn Manning 94
946474 Paul Goodman 70
Value Output Desired Output Condition 1: If Decimal value is between (.01-.09) then on
57.05 57 57
26.01 26 26 Value Output
35.68 36 36 107.08 107 107 INT
23.09 23 23
109.02 109 109 Condition 2: If Decimal value is between (.10-.99) then ne
1006.11 1007 1007
108.09 108 108 Value Output
10.1 11 10 107.1 108 108 ROUNDUP
54 54 54
34.98 35 35 Condition 3: If there is no decimal then the same number
11.17 12 12
23 23 23 Value Output
87.01 87 87 65 65
 between (.01-.09) then only integer should be taken.

between (.10-.99) then next nearest number should be taken.

ROUNDUP

mal then the same number will be taken.