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"))))

Ques. : 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.