Page 23 - C_GPT _V4 _class_7
P. 23

You have formatted the sheet well. Why don’t         Oh, you mean sorting on the
                   you arrange them in the order of calendar?               basis of Birthdays.
























                                                                                 Yes, or alphabetically according to names!




                  Test Your Knowledge                                                     21 st  Century   #Information Literacy
                                                                                              Skills
                                                                                                  #Critical Thinking
                    State 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 learnt 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. Data sorting is the process
                 of organising 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 data.











                                                                                      Advanced Features of Excel    21
   18   19   20   21   22   23   24   25   26   27   28