Page 51 - ModularV1.1 _c6_flipbook
P. 51

7.  The ................................. symbol allows us to search a file in a computer.

                    8.   We can use ................................. option in the Alignment group to combine two or more selected
                       cells into a single cell.

                    9.   In Mixed Referencing, you can lock either a column or row by preceding it with a
                       ................................. symbol.
                   10.  The SQRT function returns the ................................. of the given number.

                 C.  Write ‘T’ for true and ‘F’ for false.

                    1.   Data compression program is used to compress a large size file into a smaller     .....................
                       size file.
                    2.  Asterisk symbol is used to replace a string of characters in the search term.      .....................

                    3.  DBMS is a utility software.                                                        .....................

                    4.  We cannot change the name of a worksheet tab.                                      .....................
                    5.  AutoFill allows the user to automatically fill a number or text series.            .....................

                    6.  Combined reference is a type of cell reference.                                    .....................

                    7.   Wildcard is a special character that is used to represent one or more             .....................
                       characters while searching a file or folder.
                    8.  The LEN( ) function returns the length of the text.                                .....................

                    9.  The Ribbon contains multiple tabs, each with several groups of commands.           .....................

                   10.  Rows are denoted by numbers in a worksheet.                                        .....................

                                                             Section B

                 A.  Short answer type questions.

                    1.  What is a row and column?
                    2.  Write the names of any three general purpose software.

                    3.  Which feature of MS Excel allows us to display multiple lines of text inside a cell?

                    4.  What is the use of the CONCATENATE( ) function?

                    5.  Write the names of wildcard characters used to find a file or folder.

                 B.  Long answer type questions.
                    1.   What is the difference between Asterisk and Question mark while searching a file or folder?

                    2.  What is the difference between formula and function? Give 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   49
   46   47   48   49   50   51   52   53   54   55   56