Posts

Showing posts with the label STUDENT RESULT IN M.S EXCEL

STUDENT RESULT IN MICROSOFT EXCEL

STUDENT results in Microsoft Excel  Name Age Gender  Subject  Tom: Total obtainable mark Tmo: Total mark obtained  Average  Position. ° TOM: =  100×Number of Subject  ° TMO: type  = Sum  than double click on Sum  and high-key from the to the last subject than you close the bracket and press enter. ° Average: type Average double click on Average and highlight from the first to the last subject then close the bracket and press enter.  ° Position: type Rank a list of option will show then you double click on rank and highlight from the first to the last Average then put your comma, put dollar sign and put the first alphabet write another dollar sign put the first number then you put Column then put dollar sign again and put second alphabet then you close the bracket and press enter. ° Grade: type IF  then a list of option will appear double click on IF  then you will click on the first Average then write >=100, "A", then w...