Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 76 - CodePilot V5.0 C5
P. 76

    3.  Identify the component that displays the address of the active cell.

                                    (i)   Name Box                                 (ii)   Formula Bar

                                    (iii)   Quick Access Toolbar                   (iv)   Title Bar

                         4.   Choose the tab used to open the Backstage View for tasks like New, Open, Save, etc.

                                    (i)   View                                     (ii)   Help

                                    (iii)   File                                   (iv)   Insert

                         5.  Mark the location of the ‘Zoom’ option in an Excel window.

                                    (i)   File Tab                                 (ii)   Status Bar

                                    (iii)   Ribbon                                 (iv)   Quick Access Toolbar

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

                         1.  Excel allows you to use formulas to do simple and complex calculations.

                         2.  A workbook in Excel can contain only one worksheet.

                         3.   The Quick Access Toolbar  is a customisable toolbar.

                         4.   The Formula Bar displays various types of information about the current
                             worksheet.

                         5.  You can close an Excel window by clicking on the Close button.

                      C.  Fill in the blanks using the given hints:
                         1.   The                 is a strip containing various tabs.                            Hints

                                                                                                              Extending
                         2.                  refers to a vertical line of cells, labelled A to XFD.
                                                                                                                 Text
                         3.   Fill handle used for copying                or                a data series.     Column
                                                                                                              Workbook
                         4.                  includes  a collection  of letters,  numbers  and  special
                                                                                                                Ribbon
                             characters.                                                                       Formula

                         5.  A                 in Excel is like a notebook that holds different pages.

                      D.  Answer the following questions:
                         1.   Define a worksheet in Excel.

                      74      CodePilot (V5.0)-V

| 71 72 73 74 75 76 77 78 79 80 81 |