Page 29 - TP_Prime_v2.2_Class_6
P. 29

03

                                                      MORE ON EXCEL











                                                                            Learning Objectives
                                                                            •    Selecting Cells in a Worksheet             MORE ON EXCEL
                                                                            •  Copying/Moving Data
                                                                            •  Column Width and Row Height
                                                                             •  Inserting Rows/Columns
                                                                             •  Merging Cells
                                                                             •  Splitting Cells
                                                                             •  Formatting Spreadsheets
                                 Yesterday my teacher gave me a data         •  Customising Worksheet Tab
                                                                             •  Using Formulas to Perform Calculation
                                to enter  into  an Excel  worksheet.         •  Auto Fill                                 27
                                When I started entering data, I saw          •  Order of Operation
                                that some cells contain similar data.
                                Can I copy the data in a cell into another cell?

                                 Yes, we can copy the data in a cell into another cell. Let's learn about how to

                                copy the content of a cell.

                 In the previous class, you learnt the basics of Excel such as creating a workbook, entering
                 data and saving workbook. In this chapter, you are going to learn more about 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. To select cells in Excel, follow

                 these steps:

                    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 to which you want to make 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 a selection.
   24   25   26   27   28   29   30   31   32   33   34