Page 236 - IT_Play_V1.0 Class9
P. 236

Function                                             Result
                           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
                 IF        the 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                                                                                          1
                      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.
              Step 6:  Click on the Next button.

                           2       3






                                                                  4








                                                                  5



                                                                                                                 6



              Step 7:  To fill the range of cells to be calculated click on the Shrink button next to the Number 1 text box.



                234     Information Technology Play (Ver 1.0)-IX
   231   232   233   234   235   236   237   238   239   240   241