Page 36 - TP_iPlus_V2.1_Class8
P. 36

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

















                                                                         5  Check My data has headers checkbox if the
                                   6  Click on the Sort by box to       selected columns have a heading at the top.
                                  select a column head for sorting.





                        10 Repeat steps 6 to 8 to
                                                                                 11 Click on the OK button.
                        specify more criteria.

                  The data will be sorted according to the criteria defined.

                     Quick Byte

                      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.








                     To Sum Up

                           Excel allows users to create custom formulas to perform calculations on their data.

                           Excel also contains built-in formulas called functions that make it easy to perform
                         common calculations on data.
                           A group of selected cells is called a range.

                           A cell reference refers to a cell or a range of cells on a worksheet that can be used to
                         find the values or data.

                           Functions  are  predefined  formulas  in  Excel  to  perform  both  simple  and  complex
                         calculations.
                           A chart is a visual or graphical representation of data from a worksheet which is very
                         useful for instant analysis and decision making.



                    34
                         iPlus (Ver. 2.1)-VIII
   31   32   33   34   35   36   37   38   39   40   41