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
   209   210   211   212   213   214   215   216   217   218   219