Page 68 - Artificial Intellegence_v2.0_Class_12
P. 68

So, Yashwant has scored the highest marks and Nitin has scored the least out of all students.


        A pplying  F ilter s
         uppose you  ant to check data of those students  ho belong to the section    , then  e can apply a filter another
        feature in  alc.  his can be done as follo s
         tep      Select the data.
         tep      Click on Data   Autofilter. A drop do n icon  ill appear ne t to each column header.

























         tep       By default,  all values are selected. Click
                 on  the    ection   drop do n  and  select
                 the appropriate category from the drop-
                 down list.
         he values  ill be filtered out for section     only.

        A dding  a Passw or d to the S pr eadsheet
        There are several ways to protect your spreadsheet from unauthorised access. One way is to add a password to open
        your file.  ass ord can be added by anyone of the follo ing methods
        Click on tools   Protect Spreadsheet
        OR




              66      Touchpad Artificial Intelligence (Ver. 2.0)-XII
   63   64   65   66   67   68   69   70   71   72   73