Page 20 - TP_Pluse_V2.2_Class_6
P. 20

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
                       Ø  Auto Fill                                   Ø  Using Formulas to Perform Calculation
                       Ø  Order of Operation



                                                                                            21 st
                   Let’s PLug-in                                                         Century   #Critical Thinking
                                                                                           Skills
                    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.




                  18    Plus (Ver. 2.2)-VI
   15   16   17   18   19   20   21   22   23   24   25