Page 79 - TP_Pro_V5.1_Class5
P. 79

REVISIT



                   ▶  We need to select the cell or a range of cells to perform any function on it.
                   ▶  We can edit the text either by replacing or modifying it.

                   ▶  We use the Undo option to reverse any action performed by us.
                   ▶  We can use the Redo command to reverse actions which we may have undone.
                   ▶   We can use the Copy and Paste option to copy data in the worksheet and paste it at the same or
                     another worksheet.

                   ▶   We can use the Cut and Paste option to move data from the worksheet and paste it at another
                     location in same or another worksheet.

                   ▶  We can insert and delete cells, rows or columns.
                   ▶  The feature of entering sequential data in the cells of a worksheet is called Autofill.

                   ▶   We can increase or decrease the Row Height and Column Width of a selected cell or a range of
                     cells with a specific measurement.











                 1.  Tick ( ) the correct option.

                    a. Which of the following is the shortcut key to undo an action in Excel?
                          (i)  Ctrl + Z                                      (ii)  Ctrl + Y

                        (iii)  Ctrl + C                                     (iv)  Ctrl + A
                    b.  To select multiple cells that are not next to each other, you should:

                          (i)  Hold Shift and click the cells                (ii)  Hold Ctrl and click the cells

                        (iii)  Double-click each cell                       (iv)  Click each cell individually
                    c.  What appears around a cell when it is selected?

                          (i)  A green border                                (ii)  A red border
                        (iii)  A blue border                                (iv)  A yellow border

                    d.  The Fill Handle is used to _______________ .

                          (i)  Delete a range of cells                       (ii)  Fill cells with sequential data
                        (iii)  Select a range of cells                      (iv)  Format a cell's content

                    e.  Which tab contains the Format option in the Cells group?
                          (i)  Insert                                        (ii)  Home

                        (iii)  Design                                       (iv)  Data



                                                                                               Editing in Excel 2021  77
   74   75   76   77   78   79   80   81   82   83   84