Page 34 - Trackpad_ipro 4.1_Class8
P. 34

9  Click on the Add                                     8  Click on the Order box to select
                         Level button to define    7  Click on the Sort On box   A to Z (for text) and Smallest to
                         a new criteria.          to select Cell Values option.  Largest (for numbers).


















                                    10 Repeat steps 6 to 8 to            5  Check My data has headers checkbox if the
                                    sort Marks in previous term         selected columns have a heading at the top.
                                    column in descending order.






                       6  Click on the Sort by box to select                         11  Click on the OK button.
                      a column head for sorting.

                  The data will be sorted according to the criteria defined.
                   Clickipedia



                    The sorting can also be done through the Sort & Filter group under the Data tab by selecting

                         and      commands for sorting in ascending and descending order, respectively. To create
                    a custom sort, click on        command.






                                   If Excel was a magical library, how would you sort books and filter books you
                                   had read?


                    Reb           t



                        Excel allows users to create custom formulas to perform calculations on their data.
                        A cell reference is a cell address that can be used in a formula to denote a specific cell.
                        The equal sign tells Excel that the succeeding characters constitute a formula.
                        A group of selected cells is called a range.
                        Excel also contains built-in formulas called functions that make it easy to perform common
                        calculations on data.
                        Charts make it easier to draw comparisons, analyse growth and relationships among the
                        values.



                    32     iPro (Ver. 4.1)-VIII
   29   30   31   32   33   34   35   36   37   38   39