Page 28 - TP_Pluse_V2.2_Class_7
P. 28

3                           Advanced Features





                                                                      of Excel










                      Let’s surf

                       Ø  Sorting Data                                 Ø  Filtering Data
                       Ø  Conditional Formatting





                                                                                                  21 st
                   Let’s PLug-in                                                                Century   #Critical Thinking
                                                                                                 Skills
                     State whether these statements are True or False.
                     1.   Area chart displays the data trends over a period of time.                      __________
                     2.  A chart helps us to represent data pictorially.                                  __________
                     3.  Plot area contains the actual chart and its other components.                    __________
                     4.  Excel provides eight categories of charts.                                       __________






                  In the previous chapter, 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. 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. To sort data,
                  follow these steps:

                  Step 1:  Select a column or range of data to be sorted. In this case, we have selected the range A3:D8.
                  Step 2:   Click on the Sort & Filter command from Editing group under the Home tab. A dropdown list

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






                  26    Plus (Ver. 2.2)-VII
   23   24   25   26   27   28   29   30   31   32   33