Page 223 - CA_165_V2.0_C9_Flipbook
P. 223

2

                                3


                                                                                                     1







                 Step 4:   In  the  Sort by  section,  select the
                           column to be  sorted  from the            4                                             5
                           drop-down list.

                 Step 5:   In  the  Sort by  section,  select the
                           Ascending or  Descending radio
                           button to sort accordingly.
                 Step 6:   Click  the  OK button. The selected
                           column or range of cells will be sorted.
                                                                    6

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


                    Complete the following activities and tick on the circles:
                    ª  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)



                                                                                                Data Analysis    221
   218   219   220   221   222   223   224   225   226   227   228