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

