Page 66 - TechPluse_C6_Flipbook
P. 66

SQRT(Number)                   It returns the square root of the     Input: =SQRT(64)
                                                  given number.                         Output: 8
                   INT(Number)                    It rounds down the number to an       Input: =INT(17.95)
                                                  integer value.                        Output: 17

                   POWER(Base, Exponent)          It returns the result of a base       Input: =POWER(3,4)
                                                  raised to some exponent.              Output: 81

                  Text Functions


                           Functions                         Purpose                             Example
                   CONCATENATE                  It joins together two or more        Input: =CONCATENATE
                   (Text1,Text2)                different text strings.              (“Libre”,“Office”)

                                                                                     Output: LibreOffice
                   LEFT(Text, Number)           It returns the specified number      Input: =LEFT(“LibreOffice”,4)
                                                of characters from the left side of   Output: Libr

                                                the text string.
                   RIGHT(Text, Number)          It returns the specified number of  Input: =RIGHT(“LibreOffice”,4)
                                                characters from the right side of    Output: fice

                                                the text string.

                   MID(Text, Start, Steps) It returns the specified number of  Input: =MID(“LibreOffice”,4,7)
                                                characters from the given point to   Output: reOffic
                                                the given number of steps.

                   LEN(Text)                    It returns the length of the text    Input: =LEN(“LibreOffice”)
                                                string.                              Output: 11

                   UPPER(Text)                  It converts the text string into     Input: =UPPER(“LibreOffice”)
                                                upper case.                          Output: LIBREOFFICE

                   LOWER(Text)                  It converts the text string into     Input: =LOWER(”LibreOffice”)
                                                lower case.                          Output: libreoffice


                  Statistical Functions

                        Functions                        Purpose                                Example

                   MAX(range)             It returns the largest value in the      Input: =MAX(16,21,18,7,13)

                                          given range.                             Output: 21
                   MIN(range)             It returns the smallest value in the     Input: =MIN(16,21,18,7,13)

                                          given range.                             Output: 7






               64       Premium Edition-VI
   61   62   63   64   65   66   67   68   69   70   71