Page 291 - Trackpad IT-402_Class-IX
P. 291

The Value is represented by the data, on which the filter is to be carried out in relation to the field name chosen.

            The More Options buttons enable to edit a table taking into account regular expression, case sensitivity or duplicates.
            Like here we want to filter data that have, Field Name = Column C and Value = 78




























            Step 4:  Click on OK button to view the result.















            Advanced Filter

            An advanced filter supports up to eight filter conditions, as opposed to the three supported by the simple filter. The
            criteria for an advanced filter are stored in a sheet. The first step in creating an advanced filter is entering the filter
            criteria into the spreadsheet.

            1.  Select an empty cell in the Calc document. The empty cell may reside in any sheet in any location in the Calc
              document.
            2. Copy the column headings from the area to be filtered into the area that will contain the filter criteria.

            3.  Enter the filter criteria below the column headings. The criterion in each column of a row is connected with AND.
              The criteria from each row are connected with OR.


                    CREATING CHARTS


            Charts are considered as an effective tool of communication in a spreadsheet program. It represents the data in a
            pictorial form which is easy to read and understand. The numbers in the data when represented in a graphical form
            help us to comprehend the data in a better way.

            In OpenOffice Calc, we can insert the charts in two different ways. They are as follows:




                                                                                          Electronic Spreadsheet  291
   286   287   288   289   290   291   292   293   294   295   296