Page 71 - modular4.0
P. 71

Chapter Profile
                          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 2019 allows you to analyse the large amount of data.






                 Exercise


                 A.   Tick ( ) the correct option.

                     1.  A form displays                   record at a time.
                         a.  One                                        b.  two

                         c.   three                                     d.  many
                     2.   Which facility of Excel is used to hide data in a range of cells so that only the data that meets certain
                         criteria is visible?

                         a.  Custom Sort                                b.  Filter
                         c.   Conditional Filter                        d.  Data Validation

                     3.   Which option of Conditional Formatting is selected when you want to highlight all cells satisfying a
                         given condition?
                         a.  Top/Bottom Rules                           b.  Percent Rules

                         c.  Highlight Cell Rules                       d.  Data bars
                     4.  In which tab is Pivot table feature present?

                         a.  Home                                       b.  Formula
                         c.  Insert                                     d.  Page Layout

                     5.  Which of the following is not a tab option of Data Validation dialog box?
                         a.  Settings                                   b.  Input Message

                         c.  Error Alert                                d.  Define Range








                                                                                                   Excel as Database  69
   66   67   68   69   70   71   72   73   74   75   76