Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 81 - 2620_Birla Open Mind C-5
P. 81

    Timeline

                                A range is a collection of selected cells. It is a rectangular section of cells which are next to
                              each other and at least one side of their border is common.
                                Undo command is used to reverse the last change made by you.

                                Redo command is used to redo the last Undo action.
                                Cell contents can be edited by double clicking on the cell and typing new data as well as by
                              using the formula bar.
                                You can easily copy and move the contents of a cell, a range of cells and an entire worksheet.

                                The AutoFill feature in Excel is used to automatically fill series of data in rows and columns
                              based on the values of selected cells.

                    A.  Choose the correct option.

                            1.  Which of these is not a range?

                                     a.  F3:I9                                     b.  C20:E28
                                     c.  B6:D16                                    d.  A:3:F9

                            2.  Which key is used to edit a cell?

                                     a.  Esc key                                   b.  Enter key

                                     c.  F2 key                                    d.  Alt key

                            3.  Which of these is the keyboard shortcut to copy and paste cell contents?

                                     a.  Ctrl + Z & Ctrl + V                       b.  Ctrl + C & Shift + V
                                     c.  Ctrl + C & Ctrl + V                       d.  Shift + C & Ctrl + V

                            4.  Which of these you can't fill using AutoFill feature in Excel?

                                     a.  Numbers                                   b.  Days
                                     c.  Heights of your classmates                d.  Hours

                    B.  Fill in the blanks with the correct words.

                                                 Hints  Editing, Cell, Delete, Column, Undo

                            1.  To edit any content, you have to select the particular                     .

                            2.  To select a column, place the mouse pointer on the                        header.

                            3.                       command is used to reverse the last change made by you.
                            4.  To delete the contents of cells, select the cells and press the                   key.

                            5.  The Fill button is in the                    group under Home tab.

                                                                                        #Editing Cell Contents in Excel 2019  79

| 76 77 78 79 80 81 82 83 84 85 86 |