Page 28 - trackpad v5.1 class 6 flipbook
P. 28

LEFT(text,            It returns the specified number of characters   Input: =LEFT("Track",3)
                    num_chars)            from the start of the text string.             Output: Tra

                    RIGHT(text,           It returns the specified number of characters   Input: =RIGHT("Track",3)
                    num_chars)            from the end of the text string.               Output: ack

                                                                                         Input: =LEN("Track")
                    LEN(text)             It returns the length of the text string.
                                                                                         Output: 5
                                                                                         Input: =UPPER("Track")
                    UPPER(text)           It converts the text string into uppercase.
                                                                                         Output: TRACK

                                                                                         Input: =LOWER("Track")
                    LOWER(text)           It converts the text string into lowercase.
                                                                                         Output: track


                  For example, CONCATENATE () function:


                                                                                     2  Type =CONCATENATE(A1,B1)
                                                                                     function to concatenate two
                                                                                     strings using cell reference.
                        1  Type this data.





                  STATISTICAL AND LOGICAL FUNCTIONS
                  Some statistical and logical with their examples are given below:



                         Function                           Purpose                               Example




                                          It returns the largest value in the given range   Input: =MAX(4,16,12,9)
                    MAX(range)
                                          of numbers.                                    Output: 16

                                          It returns the smallest value in the given range   Input: =MIN(4,16,12,9)
                    MIN(range)
                                          of numbers.                                    Output: 4

                                                                                         Input: =AVERAGE(10, 12, 14)
                    AVERAGE(range)        It returns the average of a range of numbers.
                                                                                         Output: 12

                                          It returns the count of the number of values in  Input: =COUNT(4,8,12)
                    COUNT(range)
                                          the selected range.                            Output: 3
                                          It checks whether the given condition is met,  Percentage = 80
                    IF(condition, value1,   and returns value1 if the condition evaluates  Input: =IF(Percentage >= 50,
                    value2)               to  true,  and  returns value2  if the  condition  “Passed”, “Failed”)
                                          evaluates to false.                            Output: Passed






                   26   Pro (V5.1)-VI
   23   24   25   26   27   28   29   30   31   32   33