Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 12 - ClickGPT V4.0 C-5
P. 12

    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
                  then 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.

                     10     Premium Edition-V

| 7 8 9 10 11 12 13 14 15 16 17 |