Functions of MS Excel

 Follow this blog for Upcoming Posts.

Click Here to Watch Video Tutorial Or Click on above Image.

Frequently Used Functions of MS Excel-

Function are also called formulas. Function helps to make our work easier and quick. Some popular functions of MS Excel are given below.

Lower( )- This function converts the text into lowercase.

                        =Lower("RAJ")

                            raj            

Upper( )- This function converts the text into uppercase.

                        =Upper("rajat")

                            RAJAT

Concatenate( )- It help in merging two text.

                        =concatenate("Mohan"," ","Lal")

                            Mohan Lal

Power( )- This function returns the power of a number.

                        =Power(3,4)

                            81

Product( )- It returns the multiplication of numbers.

                        =Product(3,2,5)

                          3*2*5= 30

Now( )- It returns current date and time.

                        =Now( )

                    

Today( )- It returns current date.

                        =Today( )

Sqrt( )- This function returns the square root of a number. 

                        =Sqrt(81)

                            9

Rank( )- Helps in finding rank.