Page 73 - Code & Click - 5
P. 73

Info Retention

            A.    Tick [3] the correct option.

                   1.  A workbook in Excel 2016 is saved with the extension ______.

                             .exls                                          .xlsx

                             .wrbk                                          .wrks

                   2.  The number of columns in a worksheet in Excel 2016 is ______.

                             16384                                          256
                             4096                                           65536

                   3.  The default number of worksheets in Excel 2016 workbook is ______.

                             3                                              1
                             2                                              10

                   4.  The address of the active cell is displayed in the ______.

                             Formula bar                                    Title bar

                             Name box                                       Ribbon

            B.    Fill in the blanks using the Data Box.


                          Data Box     1048576     worksheet     Formula bar     spreadsheet

                   1.  A page in an Excel workbook is called a ____________.

                   2.  The number of rows in a worksheet in Excel 2016 is ____________.
                   3.  Excel 2016 is an example of ____________ software.

                   4.  The ____________ can be used to enter data or formula in a cell.

            C.     Write ‘T’ for True and ‘F’ for False statement.
                   1.  The result of some calculations is displayed on the Status bar.                    _______

                   2.  Text data includes only alphabets.                                                 _______

                   3.  The contents of an active cell are displayed in the Formula bar.                   _______
                   4.  Rows are the horizontal arrangement of cells in a worksheet.                       _______

            D.    Answer the following questions.

                   1.  What is a spreadsheet? Name two spreadsheet software.
                   2.  Write four features of Excel 2016.

                   3.  What is the difference between a workbook and a worksheet?

                   4.  Write the steps to rename a worksheet.

                                                                                                                 71
   68   69   70   71   72   73   74   75   76   77   78