Page 73 - TP_Plus_v4_Class4
P. 73

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.




                        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


                        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  71
   68   69   70   71   72   73   74   75   76   77   78