Page 65 - iPrime_V2.2_class7
P. 65

6                                           More on




                                                               Spreadsheets











                      Chapter Profile

                          Selecting Cells in a Worksheet                      Copying/Moving Data
                          Using Undo and Redo Features                        Column Width and Row Height
                          Inserting Rows/Columns                              Merging Cells
                          Formatting Spreadsheets                             Autofill
                          Using Formulas to perform Calculation               Order of Operation


                 In the previous chapter, we learnt about different components of the Excel window, such as cell,
                 row, column, formula bar, workbook, and worksheet. We also learnt the processes of creating a
                 workbook, entering data into a worksheet, and saving a workbook. In this chapter, we will learn
                 more about MS 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: A  cell range is a collection of two  or  more cells. It is of two
                   types: Contiguous Cell Range and Non-Contiguous Cell Range. Contiguous Cell Range
                   is a collection of cells that  are  adjacent  to or  next to one another.  Colon  (:) is used for
                   specifying this cell range, e.g., A1:A6. Non-contiguous Cell Range is a collection of cells that
                   are not adjacent to one another. Comma (,) is used for specifying this cell range, e.g., (A1,
                   B1, C3). 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 a selection. We can also select a range of
                   cells by using the Shift key. Click on the first cell and then press and hold down the Shift key,
                   and while holding the Shift key, click on the cell where you want your selection to end.
                    Entire Row/Column: Click on the row heading to select the entire row or click on the column
                   heading to select the entire column.
                    Entire Worksheet: Click on the Select All button located below the Name box to select the
                   entire worksheet. The shortcut key to select the entire worksheet is Ctrl + A.



                                                                                         More on Spreadsheets      63
   60   61   62   63   64   65   66   67   68   69   70