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.



Recommended Post
Big on Hosting. Unlimited Space & Unlimited Bandwidth

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…

Best Video Calling App For 2G, 3G, 4G and Wi-Fi Network

More or less every mobile subscriber wishes to chat with their contacts by seeing his/her infront of them. Now a days video calling becomes more popular in urban areas rather than rural areas. After the invention of 3G network it becomes a trend to chat with loved one through video calling. Read also : How to protect your computer from WannaCry ransomware virus.

But what happened if you have 2G network instead of 3G or 4G. Could you be able to chat with your loved one by seeing him on 2G network? There is a good news for those who wishes to see their friends or family members on mobile screen when they talk to them. There are many application software available on internet which provides video calling facility even on 2G network. Read also : How to Setup AdSense Page Level Ads and Fix Script Error.

Although there are many video calling applications are available, among them my recommendation is IMO. Because IMO provides fast, free and high quality video calling facility to its members…

How To Setup AdSense Page Level Ads on Your Website / Blog

Google has updated a new AdSense ads format called Page-level ads. This Page-level ads feature is still in beta. If you are an AdSense publisher, I am sure you are already experienced with responsive ad unit , custom ad unit size and Custom AdSense search engine. When I logged into my AdSense account today, I noticed this new ad format introduced by AdSense. Read also : How to make your blog Push Notification ready.

Whats New in Page-level Ads

According to AdSense, "Page-level ads are a family of ad formats that offers a new and innovative way for you to monetize your content. With Page-level ads, you place the same piece of ad code once on each page where you want to show the ads. Once you've added the code, Ad Exchange will automatically show Page-level ads at optimal times when they’ll perform well for you and provide a good experience for your users." This Page-level ads are only for mobile sites and it offers two kinds of  ads Anchor/overlay and Vignette ad formats.…