Page 249 - open office
P. 249

Open a worksheet. Type the name of a school, say  MI ER A Public School  (in A1 cell) and then press the
                 down arrow key to make the cell A2 as the active cell.
                  ow, in cell A2, type  PERFORMA CE REPORT . Move to row number 4. Type the headings of the data in
                 separate columns by pressing the right arrow key/mouse click: Enroll No. in column A, Name in column B,
                 Class in column C, Section in column D and Father’s Name in column E.

                  ow, we can feed data under the given headings in separate cells starting from the 5th row viz., below Enroll
                 No, Name, Class, Section and Father’s Name of each student in different row.



                            N ot e s

                            The ‘f
                                                                    mula. When the data
                                                                                         is typed
                            The ‘fx’ button is used to enter or edit formula. When the data is typed in a cell, two buttons
                            The ‘fx’ button is used to enter or edit formula. When the data is typed in a cell, two buttons
                                                        er or
                                                   o ent
                                        on is used t
                                  x’ butt
                                                             edit for
                                                                                                            o butt
                                                                                                                  ons
                                                                                                 in a cell, tw
                                                            Cr
                                                                             Tick Mark
                                                                        and
                                         the ‘f
                                      er
                                                              oss Mark
                                    af
                                                                                                      on is the check
                                      t
                                                     on, i.e.,
                                                                                      . Tick Mark
                                              x’ butt
                                                                                                  butt
                            appear
                            appear after the ‘fx’ button, i.e., Cross Mark and Tick Mark. Tick Mark button is the check
                            appear after the ‘fx’ button, i.e., Cross Mark and Tick Mark. Tick Mark button is the check
                                                       OK
                                                                                                            it
                                                           butt
                                                                                                              cancels
                                                                                 on
                                                                             butt
                                                                                                 butt
                                                                                          Cancel
                                                                                      the
                                                                                    is
                                                                  Cr
                                                               on.
                                                                                                        and
                                                                        Mark
                                                                    oss
                                                                                                     on
                                                     as
                            mark button and it works as OK button. Cross Mark button is the Cancel button and it cancels
                                  butt
                            mark button and it works as OK button. Cross Mark button is the Cancel button and it cancels
                            mark
                                      on
                                               w
                                             it
                                         and
                                                orks
                            what ev er is typed.   Aut oSum  butt on is used t o calculat e the sum o f specified range o f cells.
                            whatever is typed.  AutoSum  button is used to calculate the sum of specified range of cells.
                            whatever is typed.  AutoSum  button is used to calculate the sum of specified range of cells.
                   MOVING IN A WORKSHEET
                 To work in ‘Calc’, commands or  data  have to be entered with  the help of input devices like mouse and
                 keyboard in different cells of the worksheet. The following are some of the shortcuts for different actions in
                 the worksheet.
                 Using Mouse
                                To Select                                        Action Required
                     Single Cell                             Click on the specified cell.
                     Multiple Cell                           Drag the mouse over the range of cells.
                     A Row                                   Click on the row heading.
                     A Column                                Click on the column heading.
                     Multiple Rows                           Click on the first row number and drag till the required row.
                     Multiple Columns                        Click on the first column and drag till the required column.
                     Whole Worksheet                         Click on the uppermost left corner of the worksheet.
                 Using the Keyboard
                     To Move the Cell Pointer/Select                             Action Required
                    To move right                           Press the Right arrow or Tab.
                    To move left                            Press the  eft arrow or Shift  Tab.
                    To move above                           Press the Up arrow or Shift   Enter.
                                                                                     Working with Spreadsheet       24
   244   245   246   247   248   249   250   251   252   253   254