Page 214 - TP_IT_V1.0_C10_flipbpookl
P. 214
In the above case if any value is changed in source data (Unit Test, Term 1 Exam or Term 2 Exam) then the marks in the
Final Result sheet generated will be automatically updated.
uiz Bee By changing Amita's marks in the Term 1 Exam from 38 to 40, did you observe any change
in her final result?
GROUPS AND SUBTOTALS
In LibreOffice Calc, Groups and Subtotals is a feature that allows users to organise and summarise data within
spreadsheets.
You can group rows or columns together to create collapsible sections. This is particularly useful for organising large
sets of data, making it easier to navigate and focus on specific parts of the spreadsheet. You can collapse (–) or
expand (+) sections to hide or reveal the detailed data within each group.
To group data, perform the following steps:
Step 1: Select the Data Group and Outline Group option from the Menu bar. The Group dialog box opens.
Step 2: Select the Rows radio button to group the data on the basis of rows.
Or
Select the Columns radio button to group the data on the basis of
columns.
Step 3: Click on the OK button.
Creating Subtotals
The Subtotal tool in Calc creates the group automatically and applies common functions like sum, average on the
grouped data. It can group subtotals by using category and sorts them in ascending or descending order so that one
need not to use filters. For example, you can sum, average, count, etc., the values within each group. This provides a
way to generate summary statistics or insights for each section of the data.
212 Trackpad Information Technology (Ver. 1.0)-X

