Page 23 - Trackpad_V4.0_c6_Flpbook
P. 23

That's nice.            I have made a spreadsheet.    Have you formatted
                                                                            the data?





















                                                                                No, but I will. Our teacher has taught us in
                                                                                  the last class. Come, let's do it together.


                  Test Your Knowledge                                                          21 st  Century   #Critical Thinking
                                                                                                   Skills

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

                    b.  What is the value in the cell B4?              ______

                    c.  What is the value in the cell D2?              ______
                    d.  Which two cells have the same value?           ______

                    e.  In which cell is the cell pointer?             ______





                 In the previous class you learnt the basics of Excel such as creating a workbook, entering data and the
                 saving workbook. In this chapter you are going to learn more about Excel.


                 SELECTING CELLS IN A WORKSHEET

                 Besides  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 select the cell containing 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 you want to
                   select. Then, hold the mouse button and drag to the last cell
                   you want to include.

                     We can also select a range of cells by using the Shift key. Click on the first cell, press and hold the
                   Shift key, then click on the last cell you want to include.




                                                                                              More on Excel 2019    21
   18   19   20   21   22   23   24   25   26   27   28