Page 213 - TP_IT_V1.0_C10_flipbpookl
P. 213

Step 13:  Select the required function from Functions drop-down list. In this case, we have retained with the default
                         option (i.e. Sum function).
































                 Step 14:  Click on the Options option. When you click on Options then it will display Row labels, Column labels, and
                         Link to source data checkboxes.

                 Step 15:  Select Row label or Column label or both checkboxes, if you want to consolidate it by matching the label. But,
                         in our case, we can not select Row labels or Column labels.
                 Step 16:  Select the Link to source data check box. This will link the data consolidated. This will create a dynamic link
                         between the consolidated data and the original source ranges (Unit Test, Term1,Term2). This means that any
                         changes made to the source data will be reflected automatically in the consolidated data.

                 Step 17: Click on OK button.

































                 You will see the consolidated marks in the Final Result sheet.


                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  211
   208   209   210   211   212   213   214   215   216   217   218