Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 93 - 2612 Digimind C5
P. 93

    e.   Riya is working on an Excel worksheet and wants to select only one specific cell to enter
                            new data. She clicks on the cell, notices a green border around it and prepares to type.
                            What does the green border around the cell indicate?
                             (i)  The cell is locked                            (ii)  The cell is active

                            (iii)  The cell is hidden                           (iv)  The cell is deleted

                     2.  Fill in the blanks using the words from the help box.

                                                  Redo, Undo, Delete, Range, Autofill

                        a.  The _______________ command reverses any action performed by us.

                        b.  The _______________ option reverses back the action performed using the Undo option.
                        c.   When we select more than one cell at a time, these contiguous  cells form a _______________.

                        d.  To delete the contents of cells, select the cells and press the _______________ key.
                        e.  The feature of entering sequential data in the cells of a worksheet is called _______________.

                     3.  Write 'T' for true and 'F' for false.

                        a.   To select multiple non-adjacent cells, you need to hold down the Ctrl key while
                            clicking the cells.

                        b.  Redo can be used even if no Undo action has been performed.

                        c.   Moving data in Excel means copying it to a new location while keeping the
                            original data intact.

                        d.  The F2 key allows you to modify the text in a cell without overwriting it completely.

                        e.  The Fill Handle is used to quickly fill cells with repetitive or sequential data.

                     4.  Answer in one words.
                        a.  Name the key you press to edit a cell's contents directly.                     ____________

                        b.  Where on the interface must we click to select an entire worksheet?            ____________

                        c.  The Paste option is present under which tab?                                   ____________
                        d.  Which toolbar contains the Undo and Redo buttons?                              ____________
                        e.  Name the icon at the bottom-right of a selected cell for AutoFill.             ____________

                     5.  Think and answer.

                        a.  Define Redo command.
                            ______________________________________________________________________________

                            ______________________________________________________________________________
                        b.  How do you select an entire row in Excel?
                            ______________________________________________________________________________

                            ______________________________________________________________________________

                                                                                                   Editing in Excel 2021  91

| 88 89 90 91 92 93 94 95 96 97 98 |