Page 59 - modular4.0
P. 59

Chapter Profile
                    9.  Formulas in Excel 2019 begin with the                  sign.
                    10.   In Mixed Referencing, you can lock either a column or a row by preceding it with a
                                           symbol.


                 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.  A computer system is made up of a number of software devices.
                    3.   Appearance setting is used to install or uninstall programs on the
                        computer.

                    4.   Asterisk symbol is used to replace a string of characters in the
                        search term.

                    5.  By default, a workbook contains 4 worksheets.

                    6.  Rows are denoted by numbers in a worksheet.
                    7.   We cannot select more than one cell at a time in an Excel worksheet.

                    8.  AutoFill allows user to automatically fill a number or text series.
                    9.   Sum function returns the count of the number of values in the
                        selected range.

                    10.  The LEN( ) function returns the length of the text.

                 D.  Short answer type questions.
                    1.  Write the names of any three general purpose software.

                    2.  What is the use of the File Explorer window?

                    3.  How many columns are there in an Excel worksheet?

                    4.  What is the use of Copy command?

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

                 E.  Long answer type questions.

                    1.  What is system software? What are the different types of system software?

                    2.  When do we need to use wildcard for searching?

                    3.  How will you enter data in a worksheet?

                    4.  Write the steps to rename the worksheet tab.

                    5.  What is the difference between formula and function? Give the examples.











                                                                                                       Test Sheet 1  57
   54   55   56   57   58   59   60   61   62   63   64