Page 75 - Web_Application_v2.0_C12_Fb
P. 75

Function                                           Description

                 MIN( )          Produces the smallest value from the given set of values/range of cells.
                                 E.g., = MIN(10,20,15,25) will display 10

                                 =MIN(A1,A2,A3) Displays the smallest value of cells A1, A2 & A3.
                                 =MIN(B2:C3) Displays the smallest value of cells B2, B3, C2 & C3.
                 COUNT( )        Produces the number of arguments enclosed in small brackets.
                                 E.g., = COUNT(1,2,15,25,3,6) will display 6

                                 =COUNT(A1:A20) Displays output: 20 (If all cells i.e., A1 to A20 contain values).

                 Logical Functions

                 Logical Functions in LibreOffice Calc check the data and return the result TRUE if the condition is true, and
                 FALSE if not. Consider the syntax of logical functions and examples of their applications in the process of
                 working with the LibreOffice Calc program.

                  Function                                           Description
                              Produces true if any condition enclosed in the bracket is true, otherwise it produces false.

                   OR         E.g., =OR(5>3, 4<5, 4>15) will display true.
                              =OR(3>6; 2<1) will display FALSE.

                              Produces true if all the conditions enclosed in the bracket are true, otherwise displays false.
                   AND        E.g.,=AND (5>3, 4<5, 4>15) will display false. (As one of the conditions is false)

                              =AND(5>3, 4<5) will display TRUE.
                              If the condition in the statement is true, it will display the true part otherwise it will display the
                   IF         false part.
                              E.g., =IF(4>5,4,5) will display 5 since the condition is FALSE.

                 Entering Function in a Cell

                 Functions are entered in a cell to produce the output of data.
                 Following are the steps to enter function in a cell:
                 Step 1:   Select the cell in which the output has to be displayed
                         or function is to be inserted. (Here, cell G2 has been
                         selected to enter the function.)

                 Step 2:  Click on Insert menu from Menu bar.
                 Step 3:  Select the Function option from drop-down menu.
                         OR

                           Click on the fx button from the Formula Bar. ‘=’ sign will appear in the Formula bar and the Functions
                         Wizard dialog box appears on the screen. On the left side of the wizard, different categories for the
                         type of data, calculation or analysis are displayed like: Database, Date & Time, Financial, Logical, etc.
                         On the right side, the corresponding in-built function is displayed.
                 Step 4:  Select the Category as Mathematical from the list box.

                 Step 5:  Select the Function as SUM from drop-down menu.

                                                                                                      ICT Skills-IV  73
   70   71   72   73   74   75   76   77   78   79   80