Page 289 - Trackpad IT-402_Class-IX
P. 289
Let us study the given worksheet to understand the concept better. The cost price of all five cardboards are the same,
so we will fix the cell D7 by writing $ in front of the row number and column name to make an absolute reference as
$D$7. This cell will remain the same across the whole worksheet in a cell reference.
Mixed Referencing
The combination of a fixed row and a relative column like R$5, E$10, G$23, etc. or a fixed column and a relative row
like $F12, $R9, $H7, etc. in a cell referencing is known as mixed referencing.
In the worksheet given below, the column needs to be fixed but the row may change when the formula is copied down
or above. This is done by using the $ sign in front of the column name as shown below.
Let us prepare the given worksheet by writing the formula for the given instructions.
• Calculate the total marks of Arjun in cell E6.
• Calculate the highest marks in the weekly test.
• Calculate the lowest marks in finals.
• Calculate the 20% of weekly test marks of Shefali in cell E8.
• Calculate the percentage of Riti.
FILTERING DATA
In OpenOffice, the Filter option allows you to narrow down the search to work on the particular set of data.
In OpenOffice, there are three types of filters, which are as follows:
1. AutoFilter
2. Standard Filter
3. Advanced Filter
AutoFilter
AutoFilter is used to quickly filter the columns based on the selected data. When you select autofilter, a drop-down box
will be created in the first cell of each column. Based on the selected value from the drop-down, data in the columns
will be filtered.
Electronic Spreadsheet 289

