How To Use formulas In Microsoft Excel ?

FORMULAS IN MS EXCEL

Open Microsoft Excel by window button and it's also available on just top of the window as it is shows on Image :

Now, Spreadsheet will be open. We are making STUDENT'S DIVISION RECORD. Firstly, We write School's Name and also Standard of Class (Means which class of data we are creating).

then press Enter and type S.no; Name; Subjects, total Marks, Percentage and Grade. Fill All column and rows. when we come on Total then first we take "="sign because every starting of formula we must use it and after that we can apply formula So press =SUM(C5:H5) we can see on image.

Microsoft Excel - Advanced Excel Formulas & Functions

Use "SUM" for Addition and type C5 because we are starting to addition from C5 to H5 when we apply this formula we can see that a single colorful  line will automatically draw it's mean we calculate the value from this point to this and press Enter! The value will show. On another row we can apply this same formula or if we want to make easy work for us then simply drag the cell from down-word. It's shown on Image. 

Microsoft Excel - Excel from Beginner to Advanced

The Values will show. Next on Percentage Column ! we apply the formula by using "=" sign like =I5/600*100. Here we type I5 because total marks on I5 and 600 is total obtained and * multiply sign for multiplication with 100. we all know the formula of Percentage So here we same type here the different thing is I5 only. Press Enter and drag the cell from downward the values will show. 

Microsoft Excel - From Beginner to Expert in 6 Hours

If we decrease decimal value like: 75.8945588 to 75.89 then we click on Decrease Decimal it is on Number Tool where "$" sign Shows on Screen   

On Grade column !Before applying the formula, We must know that for how many marks we will give the grade. Here we apply the formula =IF(J5>=90,"A+",IF(J5>=80,"A",IF(J5>=70,"B",IF(J5>=60,"C",IF

(J5>=50,"D",IF(J5<=40,"FAIL")))))). In Formula we type IF (means "if" we want this or that) then we open Bracket type J5!on J5 has the value In which we will give grades. J5>=90 means if J5 value will greater than or Equal to 90 then it will give grade "A+" or J5>=80 then grade will "A" ............... and J5<=40 then will show "Fail" on that. 

                  At last the formula we can see that we have 6 Brackets Close for that how many we open the brackets we should close the brackets at last. Show on Screen Image. This is very important thing in this formula. So this according we type the formula on K4 cell! here we are giving Grades and drag downward the cell and give Grade to each Cell.

Now, at first we type School's Name and Standard of Class at Left Side. We Want in the Center of the Data Then Select The cell and click on Merge & Center tool then it will be come on Center.

If we want to Bold, Size Change, Text Come on Center or Give Border around the Data then click on Bold Button it's on Font Tool & Size changes also on Font. 

For Text Change it's on Alignment click on center if we want Center. For Border it's on Font click any border what we want on our Data.

Here Final Data Look like this :