Page 40 - modular4.0
P. 40

Chapter Profile
                                                                                                                                            Exercise



                                                                                                                                            A.   Tick ( ) the correct option.

                                                                                                                                                 1.  Where is the Select All button located on the worksheet?
                                                                                                                                                     a.  Below the formula bar                     b.  Below the name box
                                                                                                                                                     c.  On the worksheet tab                        d.  On the Zoom button
                                                                                     5  Enter the
                                                                                     Stop value.                                                 2.  What is the range of column width in Excel?
                         6  Click on OK
                        button.                                                                                                                      a.   0 to 100                                 b.  1 to 255

                                                                                                                                                     c.   1 to 1000                                d.   0 to 255
                  You can also use the AutoFill feature in a series. To do so:                                                                   3.  Which tab has the option of Cut, Copy and Paste?
                      Type the first two numbers in a series.                                                                                        a.  Home                                      b.  Insert
                      Select the cells and hover your mouse pointer over the bottom right corner of the selection.
                      Click and drag over the cells you want to autofill.                                                                            c.  Formula                                   d.  Data
                                                                                                                                                 4.  What is the default row height in Excel?
                         CUSTOMISE WORKSHEET TAB                                                                                                     a.  10 points                                 b.  8.43 points

                  To customise worksheet tab, follow the given steps:                                                                                c.  15 points                                 d.  6.43 points

                                                                                                                                            B.   Fill in the blanks using the words given below:
                                                                  2  Click on the Rename to rename the
                                                                 sheet, Tab Color to select a tab colour,                                                                   Cell formatting, quick access, autofill, shift
                                                                 or Delete to delete the sheet.
                                                                                                                                                 1.                     feature saves time to complete the text or number series.

                                                                                                                                                 2.  Undo and Redo Command is present on the                      toolbar.


                                                                                                                                                 3.  When you move or copy a cell, Excel moves or copies the entire cell contents and           .

                                                                                                                                                 4.                     key is pressed to select a range of cells.

                                                                                                                                            C.   Write ‘T’ for true and ‘F’ for false.
                                                                                                                                                 1.  It is not possible to change the row height and column width in Excel.
                                  1  Right-click on the sheet tab           3  Type in the name or select a colour
                                  that you want to customise.               you would like for your spreadsheet.                                 2.  Redo button only appears after you've undone an action.

                                                                                                                                                 3.  Only two cells can be merged in Excel.
                           Recap
                                                                                                                                                 4.  It is possible to change the sheet tab color of a worksheet in Excel.
                         The contents of a cell can be moved or copied to other cells.                                                      D.   Short answer type questions.

                        Row height and column width can be changed.
                                                                                                                                                 1.  How many ways are there to select cells in a worksheet? Name them.
                        You can specify a column width ranging from 0 to 255 and a row height ranging from 0 to 409.

                        Two or more cells can be merged into one cell.
                                                                                                                                                 2.  What is the purpose of Redo command?
                        AutoFill feature automatically fills a series of data in your worksheet.





                38   Modular (Ver. 4.0)-VII
   35   36   37   38   39   40   41   42   43   44   45