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

