Page 21 - Plus_V2.2_C6_Flipbook
P. 21

2                            More on Excel 2016
















                     Let’s surf

                         Selecting Cells in a Worksheet                 Copying/Moving Data
                         Column Width and Row Height                    Inserting Rows/Columns
                         Merging Cells                                  Splitting Cells
                         Formatting Spreadsheets                        Customising Worksheet Tab
                         AutoFill                                       Using Formulas to Perform Calculation
                         Order of Operation



                  Let’s PLug-in                                                                        Critical Thinking


                   Look at the picture and answer the questions that follow.
                   1.  How many rows and columns can you see?        ______

                   2.  What is the value in the cell B4?                       ______
                   3.  What is the value in the cell D2?                       ______
                   4.  Which two cells have the same value?             ______
                   5. In which cell is the cell pointer present?           ______



                 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.

                   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.





                                                                                              More on Excel 2016   19
   16   17   18   19   20   21   22   23   24   25   26