MS Excel - Student Mark Sheet Calculation Sum, Average, Rank, Grade, Pass Fail, Status

* View Online Course* : vedantaeducationalacademy.com/
---------------------------------------------------------------------------------------------------------------------
• Complete Accounting & Taxation Package (English) INR. 1099/-
• TallyPrime+ERP9+GST+IncomeTax+TDS+TCS+Microsoft Excel Combo Pack
vedantaeducationalacademy.com...
--------------------------------------------------------------------------------------------------------------------------------
• Computer Basics with Microsoft Office (English) INR. 699/-
vedantaeducationalacademy.com...
--------------------------------------------------------------------------------------------------------------------------------
• TallyPrime-TallyERP-GST-IncomeTax-TDS in Telugu (తెలుగులో) INR. 699/-
vedantaeducationalacademy.com...
---------------------------------------------------------------------------------------------------------------------
* Tally Official Digital & Verifiable Certifications*
• vedantaeducationalacademy.com...
* Buy Tally - Accounting Software’s *****************
vedantasoftwaresolutions.com/
-----------------------------------------------------------------------------------------------------------------------------
Download Mobile App : play.google.com/store/apps/de...
Our Contact information
Mail : [e-mail]
Mobile & WhatsApp : [phone]
Tags #excel
#onlinecourse #vedanta #vedantaeducation #ursravitelugu #ewaybill #einvoice #gst #tallyprime #tallyerp #computer #computerskills #msoffice #word #excel #powerpoint #freecourses #onlineeducation #onlineeducation #accountingcourses #incometax #tds #tcs
Visit Our Website : vedantaeducationalacademy.com/
↓↓↓Full Course Links Find Below ↓ - Vedanta Educational Academy ↓↓↓
_________________________________________________
1. Tally.ERP9 with GST Rs. 699/- vedantaeducationalacademy.com...
________________________________________________
2. MS Excel Rs. 499- vedantaeducationalacademy.com...
________________________________________________
3. Tally.ERP9 + GST + MS Excel Rs. 1049 vedantaeducationalacademy.com...
________________________________________________
4. Computer Basics - Rs. 3500 vedantaeducationalacademy.com...
________________________________________________
Full Course Links Udemy
________________________________________________
1. Tally.ERP9 with GST (Learn with Tally Authorized Faculty) - INR. 455 -
www.udemy.com/course/tally-wi...
________________________________________________
2. MS EXCEL - INR 455 -
www.udemy.com/course/master-m...
________________________________________________
3. TALLY.ERP9 + GST + MS EXCEL 9COMBO PACK) INR. 455 -
www.udemy.com/course/tally-er... #OnlineCourses #VedantaEducationalAcademy #Tally.ERP9 #GST #TallyPrime #tallyprime #Vedantu #VedantaEducationApp

[@shukussaim3472]

I was seeking for the fail and pass in one subject problem from within the month.
But now i knew it.
Thank you very much for this video.
Lots of love.

[@evelinalumato9052]

Where did he get 35 in pass or fail

[@moumitagupta8124]

Sir,the total range will be given in the question or we need to assume it as i2 and i11

[@techhack2006]

mai kisi ki bhi video pr comment bahut bahut hi rare hi chance h ki kru but sir You are brilliant Thank you so much Your Teaching Skill is osm🔥🔥I Salute you sir🔥

[@mrCetus]

Hello sir, it's a helpful video. I'm need one help. What would be the formula to find the total marks for English plus best four subjects. There are total of six subjects. Your help would be highly appreciated. Thank you!

[@Shukuruwilondja.3520]

I really love the way that you explain.

[@manojsoni1475]

A failed student is getting higher rank than who passed also status of failed students is good
Still required improvement in formula application

[@ayyappareddymandala5216]

Why did you allocate rank for failures?
Can you calculate ranks in serial order for passed out students without allocating rank for failures?

[@sandileshezi1436]

Last words knocked me out "So this is how simple it is, thank you" 🤣

[@childrenreadingskills6024]

How do I send the answers and scored points (not points allocated to the questions) of my students' marked exam papers? They did not type the email address on the exam Google form.

[@emmanuelkwesi2387]

That's a great tuition. Thanks so much.

[@samardeepsingh82]

Thanks for the video, at 9:01, you mentioned poor, shouldn't you have used if statement for less than 50 too? Just asking for clarification. 🙏

[@baaboss5036]

You are the best teacher i forgot the IF function but you remembered me thanks

[@ramngaihzuala3212]

I have a question?.... Suppose a student who failed in one subject but score more in total mark then a student who score less in total mark but pass in all the subject... So, the question is how to make a rank on this kind of situation?

[@smilemittal5164]

Sir please tell me that how to sort the list of students based on the final average marks?

[@fatiharslanoglu6482]

Thank you very much! My project worked.. Wonderful video!

[@azbz7]

the best teacher I ever found .you mastered it!!

[@shahataj1998]

Very informative thank you for teaching us

[@vinothkumar10]

thank u sir i have one doubt in case one student all subject have 35 marks 6*35=210 total another student one subject fail but this students 6-subject total 275 so how to calculate RANK ?? sir pls help me

[@rajeshakkineni4565]

nice information sir but i have a doubt .. when two students getting same marks then ranks also getting same but coming next rank person getting one rank below.... also i want to given conditions when student getting 400 above ranks on, above350 second rank like that.. how its came

[@ashivashishth9759]

Thanks it's really very helpful I love this video

[@paulataufa8160]

Hi, thank you for your excellent video demo, however i wanted to know how can you calculate the to 5 marks only and displayed on your total column?

[@AnilYadav-tt5ox]

W 4th

[@elvranjes5824]

More grace ur the best teacher 🙏🏻🙏🏻❤️

[@mohanraje5035]

Good explanation thanks 👍

[@MuhammadUsmanTaj]

Great really fruitfull tutorial

[@bhushankahar1361]

dear sir your video so excelent I was searching this kind of video . now I want how to print as a mark sheet kindly inform me . I am a teacher conducting exam, deportment , so i want to do all data works easily.

[@Alkhalil180]

This Rand formula did not work if there comes duplicate value. for example if two student gets the same number

[@thallurimoses]

is it possible to turn it into a form/software/app/interactive pdf after creating such excel, where we can enter just the marks and get the results?

[@tewodroswerku3657]

It is a very good way of teaching and I understand each and everything thank you so much

[@esmeraldaunged3039]

millions of thanks to you sir for this video.. May God bless you more with knowledge to share..

[@kevinogutu6553]

I wanted a case where there are values and grades how do you calculate total points

[@anupomkumar2123]

Suppose 3 students get the same number in total, to make the position with the help of prior class Roll,Then what is conditions to make this result Sheet?

[@macdonaldmendorinusnarib7892]

hi can you calculate how many students passed using sumif function, thank yu

[@kaeez]

How quickly Mr. Ram went from being class topper to fail 😅

[@AMITJAIN-vo7tm]

How to use if function when any student is absent in all exam or particular subject.

[@muhammadusamboaliyu5815]

Thanks very much. please how can I know my total marks range if I'm using different value

[@ShubhamSharma-ss9xk]

If i want the name of student which is having rank 1 in a different cell, how can i get that??

[@srinivasatk3907]

Hi Sir,
If a student failed also you have given the status as good you have to include this condition as well both should be satisfied.

[@poornimarao6288]

If i want to find how many have passed or failed in a vertical way, how to find out

[@b2empiretv217]

You are the best,so simple and well detailed❤❤❤

[@level2456]

Thanks for the video. How do we compile a list showing only students that failed? Separating it from those who passed

[@muradshaikh7422]

Firstly I want to give rank of the students who have passed then fail.
What is the formula?

[@madalaramesh3536]

tq sir I'm using this process
superb clarity

[@kiranbarru1918]

Sir Nice video, can we give ranks with using if formula, please give reply.

[@addissolomon2343]

thank you so much!!!

[@hec_tx12]

My exam is literally in 1h , tysmmmmmmm

[@DJ_FREESTYLE]

Very very helpful 👍☺️

[@sharfuddinahmad3311]

prepare an exam results sheets of six of your friends in six different data sheets. each sheet will contain marks in four periodic assessments in english, hindi, maths, science and social science. rename these sheets with the name of your friends. now, combine all sheets in a seventh sheet to show the total obtained by each friend in each subject by using sheet referencing. now, find the total and average marks obtained by each of your friends by using combined data of all five subjects. finally, find minimum and maximum marks obtained in every subject and in combined marks.
Can you make this video

[@miriraipetermatete7462]

This is just awesome. I was having problems with my ICT tasks

[@iddiali4102]

can i ge step by step method for creating a report system

[@sairabanu2984]

Sir,while putting rank,we are getting rank for absentees also
How to rectify this

[@coolbabysv]

Thanks for the video. If some student is failed, he should not be given ranking, also factor for absence. Then we have to calculate ranking. Is it possible

[@neelamdh2926]

Wonderful.. 🙏 Thank You

[@ravichandrareddy487]

Super explanation Sir. Sir I want to know Function Library in FORMULAS TAB . PLEASE explain Sir

[@PankajMishra-xg9vf]

Sir, If I want to display the students name based on specified range of marks, how should I do that in excel. Kindly, help me regarding this..🙏

[@aliyukabir9011]

You shall right click between the row that you want put the student's name and click on insert, the option will appear that let you to find a space

[@HariniGurudev]

Thank you brother....🎉🎉🎉
Now I can understand very well

[@akshaydarbar10]

Sir ,i hav a markshhet in this i want that students absent in all subject ..results colums shows absent instead of fail . How to write formula fr this
Becasue in result colum i hav given a condition that if a students pass in all subjects ,shows pass ,or fail then how to add absent condition for this .

[@storeone363]

you are great sir .
it was really very helpful video specially for me

[@vesetoluvese6518]

How easily you explained thank you sir

[@epicurean9866]

What if two columns will be interpreted. please help me
Ex. c2 is frustration and e1 is instructional- the interpretation is frustration
if c3 is instructional and e3 is independent- the interpretation is instructional
if c4 is independent and e4 is independent- the interpretation is independent
I have two cells to be interpreted please help me out to generate automatically

[@RajSinha]

You're superb!

[@gamerzgill8191]

if two students rank same then how this rank formula will work?

[@parvin.shaikh.]

Thank you sir for the explanation 🙏 👍 I understood how to do....thank you

[@notveryc00l]

how u rename the a b c things

[@alieaiahjawara7136]

Thanks, it's really helpful

[@avinashduttjha9608]

can anybody add a excel file here for above mentioned category

[@revolution515]

but what about "Absent" student?

[@deepaharishchandraprabhu3166]

thank you sir, well explanation

[@sajidapatel6082]

It was eassy explanation one query if I want to count how many students are fail in each subject than filter to be used count method

[@fizaz7497]

How to do rank if using average?

[@uttamdaschelak2380]

sir how to show student status fail pass and 1 sub fail is supply

[@rieru_6767]

bro casually saving my grades

[@sharmakhushi6594]

Sir hume agar sirf itna nikalna ho ki calculate the number of students failing in each subjects. Then konsa function use karenge?

[@suraiyakhan6384]

=if(select sell of total

[@changadawa9482]

nice sir now my ict work is done

[@ashishparakh8380]

Need a formula I have 2 tabs.
In Tab A I have 2 Columns, Column A is named as Students, Column B is named as Pass or Fail.
In Tab B I want to see only Passed Students.
Help me with some Formula

[@hojiihojjetaa1945]

Thank youuuu!

[@shankargupta4364]

Thank you so much for this video .😊

[@a.peterrobinson7297]

thank you very much sir, it is more useful for me. I am thankful to you sir.

[@komalarya9179]

Thankyou bro

[@angelsworld8677]

Thank you 🎉

[@zer022pg]

Thank-you the video is very helful

[@Rahul-oz7kb]

Thank you so much brother

[@virendersingh1234]

If the logical test for all the subjects are same. ..can we give them a single formula showing that if sub 1 to sub 6 less then 35 is fail

[@rajeshakkineni5127]

Simply superb

[@geneticscientistkohinoordi1539]

THANKS A LOT SIR

[@junaidjunaid7999]

Thank you 🙌

[@Short_Films709]

Thank you so much for this sir.

[@1nude1]

What if a student is absent in a particular subject?

[@subhasishmallick6183]

Thanks

[@debjanirai1235]

Thank you

[@chandaboro4457]

Thank u

[@ASHRAFTANVIR]

thank you

[@geethav7474]

Really super sir very useful to us

[@shehzadjan5638]

sir mere sat same marks same rank ha raha hai kindly koi or formula o ga

[@mohanraje5035]

How to find grade sir

[@rheajobin06]

Thank you sir!!

[@apex_soul7116]

Thanks bro ❤️

[@fauziffyt1503]

Thankyou sir

[@bhaskarpoojary4585]

Sir can we have this excel app in mobile

[@hariprasad361]

excellent explanation thank you for your valuable time for us....!