MS-Excel Tricks

Ques. : Excel program to check Odd or Even.

=IF(MOD(M22,2)=0,"EVEN","ODD")

----------  OR  -----------

=IF(ISODD(M22),"ODD","EVEN")

----------  OR  -----------

=IF(ISEVEN(M22),"EVEN","ODD")

Ques. : How to create a Grade/Division System in MS Excel.

=IF(M13>=700,"SUPER GRADE",IF(M13>=600,"A++ GRADE",IF(M13>=500,"A GRADE",IF(M13>=400,"B GRADE","FAIL"))))

Example : How to create Custom Lists in MS Excel.

File menu - Options - Advanced(Left Pane) - General Tab(Right Pane,Bottom side) - Edit Custom Lists - New Lists - Ok. 

Example : How to Repeat Heading in Each Page of MS Excel Sheet Contents.

- Open Excel page having multiple sheet contents.
- Click 'Page Layout' menu - click 'Print Titles' option - click right side image icon of 'Rows to repeat at top' box - select the rows/type the range address of rows for Heading - ok.(check using print preview)