Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 29 - 2615_KEC
P. 29

    For example, MAX () function:

                                                                                            2  Type =MAX(B3:F3)
                                                                                            function in the cell G3.

                                   1  Type this data.

                     Now press the Enter key and the maximum marks appear in cell G3. Similarly, we can find the

                     minimum marks by using the MIN() function.

                                              1.   Which function calculates the maximum value from a given set of
                                                 values?

                                                 _____________________________________________________________
                             uiz   Bee        2.  Which operator has the highest order of precedence?

                                                 _____________________________________________________________

                     MORE ON FUNCTIONS

                     Some more functions with their examples are given below:

                            Function                           Purpose                             Example

                      CONCATENATE            Joins  together  two or more  different text  Input: =CONCATENATE("Track",
                      (TEXT1, TEXT2)         strings.                                    Output: Trackpad

                      LEFT (TEXT,            Returns the specified number of characters  Input: =LEFT("Track", 3)
                      NUM_CHARS)             from the start of the text string.          Output: Tra

                      RIGHT (TEXT,           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)             Returns the length of the text string.
                                                                                         Output: 5
                                                                                         Input: =TODAY()
                      TODAY()                Returns the current date.
                                                                                         Output: 27-02-2026

                                                                                         Input: =NOW()
                      NOW()                  Returns the current system date and time.
                                                                                         Output: 27-02-2026 11:24

                                                                                     Formulas and Functions in Excel 2021  27

| 24 25 26 27 28 29 30 31 32 33 34 |