Page 29 - TP_Prime_V2.2_Class7
P. 29

3.  Long answer type questions.
                    a.  Define any two types of charts provided by Excel.

                    b.  What is the difference between sorting data and filtering data?

                    c.   Write the names of the criteria on the basis of which conditional formatting can be applied
                        in Excel.

                    d.  Write the steps to apply Custom Sort feature.

                                                                                                    21 st                   ADVANCED FEATURES OF EXCEL
                 4.  Competency-based/Application-based questions.                               Century   #Critical Thinking
                                                                                                   Skills
                    a.   Suman wants to present the information in the form of a chart. She has a data of single
                        series and the graph must show the relative circular size of each value. Which chart type
                        must she use?

                    b.   John is preparing a list of students with their marks obtained in exams. He
                        wants to arrange the data in ascending order according to the students names.
                        Suggest him a feature of Excel which helps him in doing his work quickly.
                                                                                                                          27

                    Activity Time                                                                   21 st
                                                                                                 Century   #Critical Thinking
                                                                                                   Skills
                 Look at the grid shown below and find five terms related to Excel.



                                        G     R     I     D     L     I    N     E     S     P

                                        D     F    Q      R     K    S     I     E     O     L


                                        F     U     C     H    A     R     T     S     R     E

                                        I     S     H     T     R    E     Z     F     T     G


                                        D     E     Y     C    N     D     X     S     I     E


                                        O     S    W      L    A      L    I     D     N    N


                                        F     I     L     T     E    R     I     N     G     D


                    Find Out                                                                        21 st
                                                                                                 Century   #Communication
                                                                                                   Skills
                 With the help of your teacher, find out about the previous two versions of Excel. Also, find
                 the differences between them and Excel 2016.
   24   25   26   27   28   29   30   31   32   33   34