Page 22 - TP_Plus_v4_Class7
P. 22

Take Off                                                          Century   #Information Literacy
                                                                                                 21 st
                                                                                                Skills  #Critical Thinking
                    State whether these statements are True or False.

                    1.  A chart helps us represent data pictorially.

                    2.  Area chart displays the data trends over a period of time.

                    3.  Excel provides eight categories of charts.
                    4.  Plot area contains the actual chart and its other components.





              In the previous class, you have learned about different types of charts in Excel. In this chapter you are
              going to learn how to sort and filter data. You will also learn about conditional formatting.


                   SORTING DATA


              Every day, you deal with a lot of data. It is easier to work with sorted data. Sorting of data means to
              organise the data in ascending or descending order. Ascending order means arranging the data in
              increasing order, from the smallest to the largest value. Descending order means arranging the data
              in decreasing order, from the largest to the smallest value. Excel allows you to sort both numeric and
              textual data. You can sort the data according to a particular column as well as a range of selected data.
              To sort data, follow these steps:

                                                                    2
                                                                        Click on the Sort & Filter command.











                  1   Select a column or range
                      of data to be sorted.




                                                                        Click on the Sort A to Z (for text) or Sort
                                                                     3  Smallest to Largest (for numbers) to sort
                                                                        the data in ascending order.





              Custom Sorting

              In case more than one column is to be sorted in such a way that the first column is in ascending order
              and if some data is same for more than one row, then the second column of such rows gets sorted in
              descending order. You can do this in Excel using Custom Sort.



                  20  Plus (Ver. 4.0)-VII
   17   18   19   20   21   22   23   24   25   26   27