Page 67 - Artificial Intellegence_v2.0_Class_12
P. 67

Advanced Features in Calc


            There are various advanced features of Calc. Let us learn about some of them in detail.

            S or ting  Data
            Calc spreadsheet software helps people to organise and process data by the use of columns and rows with formulas and
            some cool features. Let us understand how to sort data—arrange data alphabetically or in ascending/descending order.
             onsider the follo ing spreadsheet




























            In order to see the student obtaining the highest total,  e need to sort the data in descending order of   otal .  ollo
            the given steps
             tep      Select the data to be sorted.
             tep      Click on Data   Sort on the menu bar. The Sort dialog box will open.





























             tep       elect   ort criteria  tab and select   otal  from the drop do n list.
             tep      Then, tick on the checkbox selecting descending order.
             tep       lick on the O  button.  his  ill arrange the data in descending order of   otal  as sho n



                                                                                            IC T S ki l l s- IV  65
   62   63   64   65   66   67   68   69   70   71   72