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
   284   285   286   287   288   289   290   291   292   293   294