Page 209 - CA 165 ver 1.0 Class 9
P. 209

Lab Assignment ‘n Activity                           Subject Enrichment




                    Complete the following activities and tick on the circle.
                    ª  Make a worksheet with following headings:

                          Name of Student         Maths           Science           S. St.     Total Marks



                    ª  Insert the data of at-least 15 students.
                    ª  Find the following using built-in function:
                       l    Total Marks secured by each student

                       l    Maximum marks obtained in Maths
                       l    Minimum marks obtained in Science

                       l    Average marks scored in S. St.
                    ª  Sort the student list in descending order of ‘Total Marks’.
                    ª  Save the workbook by name ‘Result Analysis’.

                    ª  Evaluate the formulas using spreadsheet given below:









                       a.   =MAX(A1:B4)                    b.    =MIN(B1:C4)            c.  =SQRT(F4)

                       d.   =AVERAGE(A1 :A4)                e.   =ABS(F1)               f.   =ROUND(E2; 1)




                   FILTER
                 Filtering is a quick and easy way to get required information from the subset of data in a range of cells.
                 A filtered range displays only such data that meet the criteria as specified for a field. In ‘Calc’ there are
                 three options that help in filtering the range of data:


                  AutoFilter                It filters data according to specific value or string.
                  Standard Filter           It filters the data according to a given condition.

                  Advanced Filter           It does more advanced filtering, on the basis of specific criteria.


                 Unlike sorting, filtering does not rearrange a range of cells. Filtering temporarily hides the rows that
                 is not required to be displayed. It allows to edit, format and even print the range subset without
                 rearranging or moving it.
                 To Filter a range of data:

                 Step 1:   Select range of cells.


                                                                                                Data Analysis    207
   204   205   206   207   208   209   210   211   212   213   214