Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 26 - 2620_Birla Open Mind C-6
P. 26

    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.

                      24  Premium Edition-VI

| 21 22 23 24 25 26 27 28 29 30 31 |