Page 68 - iPlus_Ver_2.0_class_7
P. 68

More on Spreadsheets



                                                                                           6













                          Learning Outcomes


                              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.

                   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: 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 the Shift key down, and click on the last cell up to which we want to make the selection.

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






                    66
                         iPlus (Ver. 2.0)-VII
   63   64   65   66   67   68   69   70   71   72   73