Page 321 - TP_IT_V1.0_C9_flipbpookl
P. 321

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 sheet 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.












                 When you copy the formula entered in the cell to other cells then, you will see how the mixed cell referencing works.












                 Prepare the given sheet by writing the formula for the given instructions:














                 •  Calculate the total marks of Arjun and display the result in cell E6.

                 •  Calculate the highest marks in the weekly test and display the result in cell B9.
                 •  Calculate the lowest marks in the finals and display the result in cell D9.
                 •  Calculate 20% of Shefali's weekly test marks and display the result in cell F8.
                 •  Calculate the percentage of Riti's total marks and display the result in cell F5.


                         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 LibreOffice Calc, we can insert the charts in two different ways, which are as follows:

                 Click on the Insert → Chart option from the Menu bar.

                 OR
                 Click on the Chart icon    on the Standard toolbar.

                 A chart typically consists of the following components:



                                                                                               Electronic Spreadsheet  319
   316   317   318   319   320   321   322   323   324   325   326