Page 69 - TP_iPlus_V2.1_Class7
P. 69

More on Spreadsheets




                                                                                              6













                         Learning Outcomes


                             Selecting Cells in a Worksheet                  Copying/Moving Data


                             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 process of creating a
                 workbook, entering data into a worksheet, and saving a workbook. In this chapter, we will learn
                 more about MS Excel.

                  i +  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 the 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 where you want to make the selection. We can also select a continuous 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.





                                                                                                                  67
                                                                                          More on Spreadsheets
   64   65   66   67   68   69   70   71   72   73   74