Page 57 - TP_Modular_V2.1_Class7
P. 57

10.  What is a group of selected cells called?
                        (i)   Selection                                 (ii)  Combination

                       (iii)  Cell range                                (iv)  Cell reference

                 B.  Fill in the blanks.

                    1.  CAD is an example of ..................................
                    2.  A worksheet contains ................................. rows.
                    3.  ................................. allows you to create visual presentation of facts and information.

                    4.  The hard disk of a computer is divided into smaller parts known as ..................................
                    5.  The ................................. command is used to split a cell into more than one cells.

                    6.  In Mixed  Referencing,  you  can  lock either  a  column or  a  row  by  preceding  it with  a
                       ................................. symbol.

                    7.  The SQRT function returns the ................................. of the given number.

                                              https://www
                 C.  Write ‘T’ for true and ‘F’ for false.
                    1.  Data compression program is used to compress large sized file into a smaller       .....................
                       size file.

                    2.  Asterisk symbol is used to replace a string of characters in the search term.      .....................
                    3.  DBMS is utility software.                                                          .....................
                    4.  AutoFill allows user to automatically fill a number or text series.                .....................

                    5.  Combined reference is a type of cell reference.                                    .....................
                    6.  The LEN( ) function returns the length of the text.                                .....................
                    7.  The Ribbon contains multiple tabs, each with several groups of commands.           .....................

                                                             Section B

                 A.  Short answer type questions.

                    1.  Give an example of Desktop Publishing (DTP) software.
                    2.  Write the names of any three general purpose software.
                    3.  What is the default column width and row height?

                    4.  What is the use of the CONCATENATE( ) function?
                    5.  Write the names of wildcard characters used to find a file or folder.
                                              https://www
                 B.  Long answer type questions.
                    1.  Explain the concept of Database Management System (DBMS) software.

                    2.  What is the difference between formula and function? Give the examples.
                    3.  What is programming software? Differentiate between assembler and interpreter.

                    4.  Explain any three components of the Excel window.
                    5.  Write the steps to rename the worksheet tab.



                                                                                                Test Sheet 1      55
   52   53   54   55   56   57   58   59   60   61   62