Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 55 - 2617_JSSPS_C-5
P. 55

    A range 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 action or series of actions taken in a worksheet.
                              Redo command is used to redo the last Undo action.

                              Cell contents can be edited by replacing the cell contents and 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 other cells.

                                                       Assess Yourself

                            Choose the correct option.

                            1.   Which of the following components of Excel contains some of the most commonly used com-
                               mands?

                                      a.  Quick Access Toolbar                      b.  Title Bar

                                      c.  Active Cell                               d.  Sheet Tab
                            2.   James wants to view the worksheet in Page Layout mode. Which of the following components
                               of Excel window should he use for this?
                                      a.  Status bar                                b.  Scroll bar

                                      c.  View bar                                  d.  Formula bar
                            3.   Harleen accidentally deleted a row in Excel. Which of the following buttons should she use to
                               undo her last action?

                                      a.                                            b.

                                      c.                                            d.

                            4.  Under Home tab, which of the following commands is used to delete a cell?
                                      a.  Remove                                    b.  Autofill

                                      c.  Delete                                    d.  Copy

                            Fill in the blanks with the correct words.

                                                      Hints Cell, Spreadsheet, Series, Home

                            1.   A ____________ can be defined as text and numbers that have been organised in rows and
                               columns.
                            2.  The intersection of rows and columns is known as a ____________.

                                                                                        Introduction & Editing in Excel  53

| 50 51 52 53 54 55 56 57 58 59 60 |