Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 19 - 2615_KEC
P. 19

    What if you could use Excel to track the books you’ve read and the books   REVISIT

     you want to read? How would you rate them and what genres would you
     include?          ▶  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.

     CHANGING THE ROW HEIGHT  ▶  We use the Undo option to reverse any action performed by us.
     To change the row height to a specific value, follow the given steps:  ▶  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
     1  Select the row and click on the   another worksheet.
     Format option in the Cells group.
                       ▶   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
     2  Select the Row   cells with a specific measurement.
     Height option.

     3  Specify the new
     Row Height value.

                     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
     4  Click on OK button.
                        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  17

| 14 15 16 17 18 19 20 21 22 23 24 |