Page 27 - TP_Prime_V2.2_Class7
P. 27

Let's Revisit

                 •   We can create charts in Excel. A chart is an effective way to display data in a factorial

                   form.
                 •  Excel provides variety of chart format such as bar, column, pie, line, area, doughnut,

                   scatter, surface or radar.
                 •  Chart can be created from chart group under Insert tab in Excel.

                 •  We can easily change the style of the chart using change chart type command from type                   ADVANCED FEATURES OF EXCEL
                   group under the design tab.

                 •   Sorting  of  data  means  to  organise  the  data  in  ascending  or  descending  order.  Excel
                   allows you to sort both numeric and textual data.
                 •  Filter option in editing group under home tab allows you to see only the required data at

                   that time
                 •  Conditional formatting in Excel allows you to highlight all the cells that satisfy a particular       25

                   condition without hiding any row or column.






                                                   Mind Drill








                     Rapid fire



                 1.  Tick (3) the correct option.
                    a.  Which of the following allows you to display data in a pictorial form?

                        (i)  Chart                                    (ii)  Data

                        (iii)  Column                                 (iv)  None of these

                    b.  Where is the Sort & Filter command present?

                        (i)  Home                                     (ii)  Insert

                        (iii)  Formula                                (iv)  View
                    c.  We use Sort A to Z option to sort _______________.

                        (i)  Numbers                                  (ii)  Text

                        (iii)  Symbols                                (iv)  Time
   22   23   24   25   26   27   28   29   30   31   32