Page 66 - TP_Modular_V2.1_Class7
P. 66

Recap


                          A database implies that organising the data in a manner which helps to store and retrieve a
                           large amount of data efficiently.
                          A form is a window used to display or enter a record in an Excel worksheet.
                          Custom Sort is used to apply sorting on more than one column in selected range on different
                           criteria.
                          Excel can apply filters to show only required information and hide the unwanted information.
                          Conditional Formatting can be applied on the basis of various criteria.
                          Data validation means to restrict the user to enter a specific range of values in a particular
                           cell or a range of cells.
                          The Subtotal command allows you to calculate group-wise sum.
                          The Pivot Table feature of Excel 2016 allows you to analyse the large amount of data.



                                                         Exercise



                  A.  Tick ( ) the correct option.
                     1.  Which of the following is called field in a database?
                          a.  Column                                      b.  Row

                          c.  Cell                                        d.  Table

                     2.  Which of the following is a window used to display or enter a record in an Excel worksheet?
                          a.  Row                                         b.  Form

                          c.  Textbox                                     d.  Database
                     3.  Which of the following options is used to search a record in a form?

                          a.  New                                         b.  Criteria

                          c.  Clear                                       d.  Filter
                     4.  We use Sort A to Z option to sort ............................

                          a.  Numbers                                     b.  Text
                          c.  Symbols                                     d.  Shapes

                     5.  In which group of the Data tab is the Data Validation command present?
                          a.  Data Tools                                  b  Outline

                          c.  Sort & Filter                               d.  Charts

                  B.  Fill in the blanks using the words given below:



                                         Conditional formatting, Subtotal, Record, Database, Pivot table


                     1.  A set of values for the fields is called a ..................................


                   64       Modular (Ver. 2.1)-VII
   61   62   63   64   65   66   67   68   69   70   71