Page 24 - TP_Plus_v4_Class6
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 in the image?   ______

                    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.  Which is the active cell?                             ______






              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.

                  To select a Single Cell: Click on the cell to select it.
                   To select a Group of Cells or Range: Click on the first cell from
                 where you want to start the selection and drag the mouse
                 diagonally 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           Shortcut to select entire
                 the Name box to select the entire worksheet.                                 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