Page 35 - ModularV1.1 _c6_flipbook
P. 35

Exercise



                 A.  Tick ( ) the correct option.
                    1.  The Ctrl + Z key is used to perform the ............................... operation.

                      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 existing content of a cell by ............................... on it.

                      a. Selecting                         b. Double-clicking            c. Clicking

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


                    5.  Which feature automatically fills a series of data in your worksheet?
                      a. AutoFill                          b. Cell Fill                  c. Wrap Text


                 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 cells.

                    3.  We can select the 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.  Merge allows the user to automatically fill a number or text series.               .....................
                    5.  The contents of a cell can be moved or copied to other cells.                      .....................


                 D.  Short answer type questions.

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


                                                                                             Editing in MS Excel  33
   30   31   32   33   34   35   36   37   38   39   40