Page 46 - Computer Genius Class 07
P. 46

exercise




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

                          (i)  Column                                         (ii)  Row

                        (iii)  Cell                                          (iv)  Form
                      2.  Which of the following is a window used to display or enter a record in an Excel worksheet?

                          (i)  Row                                            (ii)  Form

                        (iii)  Textbox                                       (iv)  Column
                      3.  Which of the following options is used to search a record in a form?

                           i    e                                             (ii)  Criteria

                        (iii)  Clear                                         (iv)  Outline
                      4.  In which tab is the Data Validation command present?

                          (i)  Data                                           (ii)  Insert

                        (iii)  Home                                           i     one o  these

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

                                   conditional  ormatting   su total   record   data ase   pivot table

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

                      2.   A                  contains data in the form of rows and columns.
                      3.   Color Scales is a feature available in             .
                      4.   The                  command allo s you to calculate group  ise sum.

                      5.   The                   eature o    cel 2 1  allo s to consolidate  summarise and present data.
                  C.  State whether these statements are true or false.

                      1.   Highlight Cells Rules option is selected when you want to highlight all cells
                         satisfying a given condition.
                      2.   The filters once applied can be easily removed.

                      3.   A form displays only one record at a time.
                      4.   We cannot add records using form.
                       .    e ore using the Su total command  data must  e sorted in ascending or
                         descending order.

                  D.  Answer the following questions:
                      1.  What is data validation?




                       44    Computer Genius-VII
   41   42   43   44   45   46   47   48   49   50   51