Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 23 - 2610_Springdales_C-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 |