Page 187 - CA_165_V2.0_C9_Flipbook
P. 187

A new spreadsheet displaying the active Sheet1 appears on the screen with cell A1 as the active cell.
                 The shortcut to open a new Calc document with a default blank spreadsheet is Ctrl + N.
                   ENTERING DATA IN SHEET


                 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 sheet:



























                 Step 1:   Open a spreadsheet.
                 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 SHEET

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





                                                                                    Working with Spreadsheet     185
   182   183   184   185   186   187   188   189   190   191   192