Page 60 - ModularV1.1 _c6_flipbook
P. 60

Recap


                           A database implies organising the data in a manner that 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  the  required  information  and  hide  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 MS Excel allows you to analyse a 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

                     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


                     3.  Which of the following options is used to search a record in a form?
                       a. New                               b. Criteria                   c. Clear

                     4.  We use Sort A to Z option to sort ........................... .
                       a. Numbers                           b. Text                       c. Symbols

                     5.  In which group of the Data tab is the Data Validation command present?

                       a. Data Tools                        b. Outline                    c. Sort & Filter


                  B.  Write ‘T’ for true and ‘F’ for false.
                     1.  Excel can arrange data in ascending order only.                                     .....................

                     2.  You cannot sort more than one column at a time in a selected range of cells.        .....................

                     3.  A form displays only one record at a time.                                          .....................

                     4.  We cannot add records using form.                                                   .....................

                     5.   Before using the Subtotal command, data must be sorted in ascending or             .....................
                        descending order.



                  58      Modular (Ver. 1.1)-VII
   55   56   57   58   59   60   61   62   63   64   65