Page 24 - Plus V4 with Adobe class 6
P. 24

Take Off                                                           Century   #Critical Thinking
                                                                                            21 st
                                                                                           Skills
              Look at the picture and answer the questions that follow:
              a.  How many rows and columns can you see?         ______

              b.  What is the value in the cell B4?              ______

              c.  What is the value in the cell D2?              ______
              d.  Which two cells have the same value?           ______

              e.  In which cell is the cell pointer?             ______






        In the previous class you learnt the basics of Excel such as creating a workbook, entering data and
        saving workbook. In this chapter you are going to learn more about Excel.


             SELECTING CELLS IN A WORKSHEET

        Apart from entering data into a worksheet, Excel also provides the facility to perform various other
        operations with data such as modifying, inserting, moving/copying and deleting. To perform all these
        operations, we first need to select the cell that contains data. Excel allows us to select a single cell or a
        group of cells.

            Single Cell: Click on the cell to select it.

             Group of Cells or Range: Click on the first cell from where you
           want to start the selection and drag the mouse diagonally up
           to the cell to which you want to make selection.
            We can also select a range of cells by using the Shift key. Click
           on the first cell and then press and hold the Shift key and click
           on the last cell up to which we want to make a selection.
             Entire Row/Column: Click on the row heading to select the entire                    Hintbot
           row or click on the column heading to select the entire column.
             Entire Worksheet: Click on the Select All button located below         To select entire worksheet:
           the Name box to select the entire worksheet.                                       Ctrl + A

        Modifying Cell Content

        To modify the cell content in a worksheet, follow these steps:


          1   Enter the  data into
              worksheet.

              Double-click on the
          2   cell whose content
              we want to change.




            22  Plus (Ver. 4.0)-VI
   19   20   21   22   23   24   25   26   27   28   29