Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 29 - 2629_Devagiri_C-7
P. 29

    Let us understand text functions, by taking an example of the CONCATENATE() function:

                         1    Type the given data   2    Type =CONCATENATE(B2," ",C2)
                         in the Excel worksheet.         and press the Enter key.

                     STATISTICAL AND LOGICAL FUNCTIONS

                     Statistical functions perform calculations on data to summarise or analyse it (e.g., AVERAGE,
                     MAX and MIN). Logical functions evaluate conditions and return values based on whether those
                     conditions are true or false (e.g., IF).

                     Let us understand logical functions, by taking an example of the IF() function.

                             1    Type the given data   2    Type =IF(C2 > 12,  Pass ,
                             in the Excel worksheet.  "Fail") and press the Enter key.            SHORT SIGN

                                                                                                To copy the content of
                     DATE AND TIME FUNCTIONS                                                   the cell above: Ctrl + D

                     These functions help you work with dates and times, allowing you
                     to extract parts of a date (e.g., TODAY, DAY or NOW) and perform
                     various date-time operations.

                                                                                                                      27
                                                                                                         Excel in Excel

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