Page 175 - CA 165 ver 1.0 Class 9
P. 175

ENTERING DATA IN WORKSHEET

                 To work in Calc, data needs to be entered. To begin entering the data, click on the cell. While typing,
                 the data can also be seen in the Formula bar.
                 After typing the data, press ‘Enter key’ or move the cursor and click on some other cell. Consider an
                 example, to work on a worksheet:






























                 Step 1:   Open a worksheet.

                 Step 2:   Type the name of your School, say ‘ABC Public School’ (in A1 cell) and then press the down
                          arrow key to make the cell A2 as the active cell.

                 Step 3:   Now, in cell A2, type “PERFORMANCE REPORT”.

                 Step 4:   Move to row 4, type the headings of the data in separate columns by navigating towards right
                          by pressing right arrow key/mouse click: Enroll No, Name, Class, Section and Father’s Name in
                          A, B, C, D & E columns respectively.
                 Step 5:   Feed data under the given headings in separate cells starting from 5th row viz., Enroll No,
                          Name, Class, Section and Father’s Name of different students in each row.
                           Notes

                           The ‘fx’ button is used to enter or edit a formula. When data is typed in a cell, two buttons appear
                           after the ‘fx’ button, i.e., cross (û) and Tick Mark (ü). Tick mark button is the check mark button and
                           it works as OK button. Cross Mark (û) button is the Cancel button and it cancels whatever is typed.




                   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. Following are some of the shortcuts for different actions
                 in the worksheet.







                                                                                    Working with Spreadsheet     173
   170   171   172   173   174   175   176   177   178   179   180