Calculate maximum, minimum and grade in excel

 How to find maximum minimum and grade in the Microsoft excel

To find maximum, minimum  and  grade Microsoft Excel.

first of all enter your data in work book  by click window button in a keyboard then click all progam from menu displayed choose Microsoft excel. After choose it the workbook will open. By default the workbook has three active worksheet named sheet1, sheet2, sheet3.

Start to write your data in active in active sheet. After filling data in Excel you can format your data by changing font size, font text board then you can align text to left to right. Justify or to centre.

How to align text in Microsoft excel?

In order to align text in Microsoft excel  click the cell which you wish to align then in a menu bar click home then in point at center of ribbon then choose alignment you wish to use. If you have many cell you need to align at a same position at once select all cell which you need to align then go to the alignment button at a center of the ribbon and choose the types of align you need Add column or row of sum, average, minimum, maximum and grade in your work. This is because you cannot get grade before get sum and average of your data in excel.

See the below diagram


 Start to find sum>average>maximum>minimum>grade 

To find sum of mark data to each client you can read here full information

 In simply  use This =SUM(B4:D4)

READ MORE ABOUT SUM CLICK HERE

Click cell you wish to add sum of the first student or client data then write this formula Above then click enter where by B4 and D4 are the are the marks of first subject 1 and subject 3

After write above formula click enter the total marks will display marks of first student who need to get total marks  point the mouse in bottom right corner the plus sign will display hold drag and drop to all student .the total marks of each student will display  in the total column of each student or client 

Then click first average cell in order to find average of each student marks  then write this formula =AVERAGE (B4:D4)

Then click enter button  where by B4 and D4  are the marks of first student who need to get average marks  point the mouse in bottom right corner the plus sign will display hold drag and drop to all student .the average marks of each student will display  in the average column of each student or client

Read more about AVERAGE CLICK HERE

To find maximum go to maximum column click cell which you need to display the maximum mark of first student  then enter this formula in in diagram below



 Click enter button the maximum mark of the first student will display. 

To get the maximum mark of other student  marks.  Point the mouse in bottom right corner of the first maximum mark  then plus sign will display hold drag and drop to all student the maximum mark of each student will display  in the maximum column of each student or client To find minimum go to minimum column click cell which you need to display the minimum mark of first student then enter this formula below


Click enter button the minimum mark of the first student will display. To get the minimum mark of other student  marks.  Point the mouse in bottom right corner of the first minimum mark  then plus sign will display hold drag and drop to all student the minimum mark of each student will display  in the minimum column of each student or client

Then to find grade of the student marks we use the average column. The formula of calculate ting average is known as IF FUNCTION. Click the cell which you wish to display grade of first student then write the formula below


This formula means that for a student have average from 80 to 100 the grade display is A , the student with average from 70 to 79 the grade display is B, for the student with average from 60 to 69 the grade display C, all student with average less than 60 the garage display F.



Post a Comment

Previous Post Next Post