Page 66 - Trackpad_ipro 4.1_Class7
P. 66

More on Spreadsheets





                                                                                 Chapter
                                                                                 06





                                 Your Aim

                                 to learn about:

                                    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 process 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 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 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.




                    64     iPro (Ver. 4.1)-VII
   61   62   63   64   65   66   67   68   69   70   71