Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 79 - 2607_Trackpad_Pro_5.1_flipbook_C5
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 |