Page 62 - iPro_trackGPT_V5_Class7
P. 62

6


                    More on Spreadsheets













                       Goal Glimpse

                          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                              Auto Fill

                          Using Formulas to Perform Calculation                Order of Operation




                  In the previous chapter, we have learnt about various components of the Excel window, including
                  cells, rows, columns, the formula bar, workbooks, and worksheets. We also learned how to create
                  a workbook, enter data into a worksheet, and save the workbook. In this chapter, we will explore
                  more features of Microsoft Excel.

                     SELECTING CELLS IN A WORKSHEET

                  In addition to entering data into a worksheet, Excel allows you to perform various operations
                  on the data, including modifying, inserting, moving/copying, and deleting. To carry out these
                  operations, you first need to select the cell containing 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 to end 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.


                    60    TrackGPT iPRO (V5.0)-VII
   57   58   59   60   61   62   63   64   65   66   67