Page 59 - TP-Play_V-2.0_Book-5
P. 59

Exercise



            A.  Tick ( ) the correct option.

                1.  Which operation is performed with the help of Ctrl + Z?

                   a.  Undo                      b.  Cut                              c.  Redo

                2.  You can specify a column width of 0 to ............................... .
                 a.  255                         b.  256                              c.  409

               3.  We can edit the content of a cell by ............................... on it.
                 a.  Right-clicking              b.  Double-clicking                  c.  Clicking

               4.  If we add an equal to sign in the beginning of the data, Excel 2016 considers it as
                  ....................... .
                 a.  Text                        b.  Number                           c.  Formula


            B.  Fill in the blanks using the words given below.


                                          Unmerge Cells, Select all, Insert, Merge & Center


               1.  The ................................. button in cells group under the Home tab is used to add a
                  column into a worksheet.

               2. The ................................. command is used to split a cell into more than one cell.

               3. We can select entire worksheet by clicking on the ................................. button.
               4.  We can use ................................. option in the Alignment group to combine two or
                  more selected cells into a single cell.


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

               1. We cannot select more than one cell at a time in an Excel worksheet.               .....................
               2. We cannot change the name of a worksheet tab.                                      .....................

               3. We cannot merge two or more cells.                                                 .....................

               4. AutoFill allows user to automatically fill a number or text series.                .....................

            D.  Short answer type questions:

               1.  Can we unmerge the merged cells? If yes, write the name of the command used to
                  do so.

                  .......................................................................................................................................................................
               2. What is the use of Copy command?

                  .......................................................................................................................................................................


                                                                                   Editing in Excel 2016     59
   54   55   56   57   58   59   60   61   62   63   64