Skip to main content

Calculation of Total Marks, Percentage, Division, Remarks, Maximum & Minimum Number of Students in MS Excel

In this post, I will help you to learn how to calculate total marks, percentage, division, maximum number, minimum number and remarks of students of a class very fast. At first you need to look over the above image very carefully. The above image shows the marks obtained by six students of a class.

Formula to calculate Total Marks of all students within seconds 

First you need to find out the Total Mark of a single student who is on the top of the list i.e, Mani. To calculate Total Mark of Mani, click on the Total Mark cell address of Mani i.e, H6 and then type the formula =sum(1st subject's cell address i.e, b6:last subject's cell address i.e, g6) and then press Enter on the keyboard or click anywhere on the worksheet. Here b6 and g6 are cell address of 1st subject (English) and last subject (Biology) of that student. Read also : How to Enable HTTPS for Blogger Blog.

After getting results, click on the resultant cell address of Total Mark of the 1st student i.e., Mani and place your mouse pointer bottom of the right side corner of that resultant cell. When you hover mouse pointer, it becomes + signs. Now keep press left mouse button and drag to the cell address of the last student (Salman) i.e., h11. Once you release mouse pointer, Total Marks obtained by rest of the students will be displayed. Read also: How to protect your computer from WannaCry ransomware.

Formula to calculate Percentage (%) of all students within seconds

First you need to find out the percentage of a single student who is on the top of the list i.e, Mani. To calculate percentage of Mani, click on the percentage cell address of the first student i.e, I6 and then type the formula =Total Mark obtained by 1st student i.e., h6/number of subjects i.e, 6 and press Enter on the keyboard or click anywhere on the worksheet. Read also How to setup AdSense Page Level Ads.

After getting results, click on the resultant cell address of percentage of 1st student i.e., Mani and place mouse pointer bottom of the right side corner of the resultant cell. When mouse pointer becomes + sign keep press left mouse button and drag to the cell address of the last student (Salman) i.e., I11 . Once you leave mouse pointer percentage of rest of the students will be displayed.

Formula to calculate Division of all students within seconds

First you need to find out the Division of a single student (1st student) who is on the top of the list i.e, Mani. To calculate Division of the 1st student i.e., Mani, click on the Division cell address against 1st student i.e, Mani (cell address J6) and then type the formula =If(I6>=80, “Distinction”, If(I6>=60, “1st Division”, if (I6>=40, “2nd Division”, if(I6>=30, “3rd Division”, “Fail”)))) and press Enter on the keyboard or click anywhere on the worksheet. Read also : How to change UC browser default download path.

After getting results, click on the resultant cell address of Division of 1st student i.e., Mani and place mouse pointer bottom of the right side corner of that resultant cell. When mouse pointer becomes + sign keep press left mouse button and drag to the last student's cell address i.e., J11. Once you leave mouse pointer Division of rest of the students will be displayed.

Formula to calculate Maximum number obtained in a subject 

First you need to find out the Maximum number obtained in a subject of a single (1st student) student who is on the top of the list i.e, Mani. To calculate the Maximum number obtained by the 1st student in a subject, click on the Maximum number cell address against 1st student i.e., Mani (K6) and then type the formula =max(1st subject's cell address i.e., for Mani it is b6:last subject's cell address i.e., for Mani it is g6 for Mani) and then press Enter on the keyboard or click anywhere on the worksheet. Read also : How to make money online from home.

After getting results, click on the resultant cell address of Maximum number obtained in a subject by 1st student i.e., Mani and then place the mouse pointer bottom of the right side corner of that resultant cell. When mouse pointer becomes + sign keep press left mouse button and drag to the cell address of the last student i.e., Salman K11. Once you release the mouse pointer Maximum number will be displayed obtained by the rest of the students. Read also How to record your computer screen in Windows.

Formula to calculate Minimum number obtained in a subject 

First you need to find out the Minimum number obtained by the 1st student i.e, Mani in a subject. To calculate Minimum number obtained by the 1st student i.e., Mani in a subject, click on the Minimum number cell address against 1st student i.e, for Mani L6 and then type the formula =min(1st subject's cell address i.e., for Mani it is b6:last subject's cell address i.e., for Mani it is g6) and then press Enter on the keyboard or click anywhere on the worksheet. Read also : How to Make Your Blog Push Notification Ready.

After getting results, click on the resultant cell address of Minimum number obtained by the 1st student in a subject and then place mouse pointer bottom of the right side corner of that resultant cell. When mouse pointer becomes + sign keep press left mouse button and drag to the cell address of the last student i.e., for Salman it is L11. Once you leave mouse pointer Minimum number will be displayed obtained by the rest of the students. Read also : How to create AdSense Search Engine and Make Money from it.

Formula to calculate Remarks (Pass or Fail) of students 

First you need to find out the remarks of a single student who is on the top of the list i.e, Mani. To calculate remarks of 1st student i.e., Mani, click on the remarks cell address against the 1st student i.e, for Mani it is M6 and then type the formula =if(cell address of 1st student's percentage  i.e., for Mani it is I6>=30, "Pass", "Fail") and then press Enter on the keyboard or click anywhere on the worksheet. Read also : How to track lost/stolen android phone and secure data.

After getting results, click on the resultant cell address of remarks of 1st student and hover mouse pointer bottom of the right side corner of that resultant cell. When mouse pointer becomes + sign keep press left mouse button and drag to the cell address of the last student i.e., for Salman it is M11. Once you release mouse pointer remarks of rest of the students will be displayed.

Thanks for reading this post. Feel free to share your views in comment box and appreciate me by this post on social networks.



Comments

Popular posts from this blog

How To Change Default File Download Path in UC Browser

All of us known that UC browser is the most popular, fast and less data consuming mobile browser for android devices. Many of us use UC browser on daily basis on our smart phones. By default UC browser has download path to internal memory device which is /storage/sdcard0/download. sdcard0 is the built in memory or internal memory of your device. Read also : How to fix HTTP and HTTPS Mixed Content Errors.

Do you know that this default download path can be changed? Since, internal memory is fixed, and once you exceed this value you can't download more. You need to move some data from mobile memory to the external memory which is sdcard1. If you change this default path to external memory card (sdcard1), you can download more data directly to your desired directory. Read also : How to Setup AdSense Page Level Ads and Fix Script Error.

Here, I will show you, how to change this default download path from internal memory card sdcard0 to external memory card sdcard1. To do so you need to…

How To Rename A WhatsApp Group

We all know that WhatsApp is the most popular messaging service for Android, BlackBerry, iPhone and for other platforms. In this post, I will show you how to rename an existing WhatsApp group. To rename an existing WhatsApp group your smartphone must have internet connection. After that you need to follow the below steps. Read also : How to track lost/stolen mobile phone and erase data remotely.


Step 1. Open WhatsApp application on your smartphone.

Step 2. After that you need to click CHATS tab and click on your group name.



Step 3. Once you click on your group name, you will able to see chat details. Now you need to click vertical dots located extremely top right corner and then click Group info. Read also : How to setup AdSense page level ads.


Step 4. Now you can easily rename your group. To rename the group just click Edit icon and then type the desired group name and click OK. Read also : How to protect your computer from WannaCry ransomware virus.


In this way you can rename a What…

Change UC Browser Default Homepage in Android Phones

We all know that Android OS operated Smartphones and Tablets are great for web browsing. Like other browsers, uc browser has a default search engine Yahoo is set for web search. UC browser provides different kind of search facilities under 5 different categories namely Web, Video, Shop, Image and APP. Read also : How to protect your computer from WannaCry ransomware virus.

In this post, I will show you how to change the default search engines of uc browser in Android devices for their 5 different categories. To do so you just need to follow the below steps. Read also : How to Enable HTTPS for Blogger Blog.

Change Default Homepage for UC Web search

Step 1. At first you need to open UC browser
Step 2. After that click Search. Follow the below image.


Step 3. Once you click Search, you will able to see the default search engine's icon for Web search like y for Yahoo, g for Google. Now you need to click that search icon. Follow the below image. Read also : How to change UC browser defaul…

Enable Auto Save Forms & Passwords in UC Browser

Many of you use UC browser on daily basis on your smart phone but very less enable this feature. Enabling auto save forms and passwords allows the browser to remember the username and passwords. It gives you relief from entering username & password every time whenever you login to your email. Did you enable auto saving form & password? If not, then do it now. Read also : How to track lost/stolen mobile phone and erase data remotely.

In this post, I will show you how to enable auto save forms & password in UC browser in your Android phones. To do so you need to follow the below steps.

Steps to enable auto save forms and passwords

Step 1. At first open UC browser

Step 2. In the second step, tap on the horizontal bar.


On the next image, you will able to see Bookmarks, History, Refresh etc. icons. Now swipe this menu screen to the left and tap Settings. Read also : How to create custom AdSense Search Engine and make money from it.


Step 3.  Now on the Browser Settings, you w…

Bad Effects of Dendrite

As we all know that dendrite is a good popular adhesive and P. C. Chandra's Chemical Enterprises Pvt. Ltd. is the manufacturer of dendrite. It is broadly used in various sectors like Engineering, Automobile, Footwear, Lather Craft, Home Decor, Carpenters and also for repairing punctured tyres. It contains a substance called toluene. Toluene is a sweet smelling and intoxicating hydrocarbon which is called neurotoxin. When these intoxicants are smeared on a piece of cloth and inhaled, the user feel euphoric (high and experience a sense of invincibility). But they dissolve the membrane of the brain cell and causes hallucinations.



When I was returning from my hometown by train I had noticed at the New Jalpaiguri (NJP) train station that some children mostly rag-pickers were keeping their handkerchief / polythene on their mouth and breathing through it and some smelling their handkerchief. Some of them are were half-naked, bare feet and had a broom in their hands also. All were between…

Change SMS Storage Location in Android Device

By default all the SMS that you have got from friends and mobile operators are stored in either SIM card or phone memory. There is a limited space in the SIM card to store your SMS. If the limitation exceeds all SMS you have got is start storing in phone memory. In this post I will discuss how to change default SMS storage location from Phone memory to SIM card in Android devices. To change the SMS storage location, you just need to perform the below steps.

Step 1. At first you need to open the Messaging application from the app screen. After that, you need to touch the Menu icon i.e., the three vertical dots of top right corner and then need to touch Settings.


Step 2. SMS Settings screen opens. Here, you need to touch Text Message(SMS).


Step 3. Now you need to touch SMS Storage Location. If you use dual SIM card on your Android device then you just need to select the desired mobile operator for which you want to change the SMS storage location either from Phone memory to SIM or SIM …