Page 148 - IT_V1.0_Class10
P. 148

21 st
                                                 Lab Assignment ‘n Activity                    Century   #Technology Literacy
                                                                                                 Skills


                   Complete the following activity and tick the circle.

                   A school conducts three tests in a year. The marks obtained by students in each test are stored
                   in separate sheets of a spreadsheet. Create a sheet named “Overall Performance” to calculate
                   the average marks obtained by each student in all three tests.


                          Notes


                          If you are continually working with the same range of data, then you can create a range and give it a
                          name. This will make the process easy and fast. The steps to define range are:

                          Data > Define Range



                 GROUP AND OUTLINE

              Group and Outline in Calc allows you to organise selected data by creating an outline, it lets you group rows
              or columns together. This feature enables you to collapse (-) to hide data or expand (+) it with a single click.

              Step 1:  Select the data you want to group.
              Step 2:  Click on Data menu.

              Step 3:  Select Group and Outline option. A drop-down menu appears.
              Step 4:  Click on Group option. The Group dialog box appears.

              Step 5:  Select Rows radio button to group by rows or Columns radio button to group by columns.
              Step 6:  Click OK button to group the data.

                                        2











                  1


                                                                     5

                  3                                             4                                                 6



                 SUBTOTALS

              LibreOffice Calc offers the Subtotals tool to create subtotals for data arranged in labelled columns. It also
              groups  subtotals  by  category  and  sorts them  automatically,  thereby  eliminating the  need  to  apply  filter
              categories manually.



                146     Information Technology Play (Ver 1.0)-X
   143   144   145   146   147   148   149   150   151   152   153