Page 63 - Web_Application_v2.0_C12_Fb
P. 63

Status Bar
                 It lies at the bottom of the screen. It shows the current status of an active application.

                 Sheet Tab
                 It lies below the active sheet of the screen. The names of the sheets appear in the sheet tabs at the bottom of
                 the spreadsheet. Click on the specific sheet tab to open it.

                 Horizontal Scroll Bar
                 It lies below the sheet tabs. It helps to view the spreadsheet screen by moving the scroll button from left to
                 right and vice-versa.

                 Vertical Scroll Bar

                 It lies towards the right side of the spreadsheet. It helps to view the spreadsheet by moving the scroll button
                 from top to bottom and vice-versa.
                 Control Buttons

                 Control buttons are essential interface elements that allow users to execute commands, such as minimizing,
                 maximizing, or closing a window.

                   3.4 PERFORMING BASIC OPERATIONS IN A SPREADSHEET

                 A spreadsheet allows you to enter, edit and delete data and use data functions. Let us see the functions that
                 spreadsheet allows you to perform.

                 Entering Data in Sheet
                 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 the Enter key or move the cursor to the other cell or click on the other cell using
                 mouse. Consider an example to work on a spreadsheet:

                 Open a new spreadsheet. Type the name of a school,
                 say ‘ABC Public School’ in A1 cell and then press the
                 down arrow key to make the cell A2 as the active cell.
                 Now, in cell A2, type  'Performance Report'.  Move to
                 row number 3. 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.

                 Now, we can feed data under the given headings in separate cells starting from the 4th row viz., below the
                 separate column headings.
                 To enter the formula in the cell, you need to first select the cell and
                 then enter a formula. For example, to add the two values 5 and 3, you
                 need to type =5+ 3 in the cell.

                 Different Types of Data
                 To begin working with a Calc, the user has to feed data. Data can be classified into numeric, text, date/time
                 and formula.


                                                                                                      ICT Skills-IV  61
   58   59   60   61   62   63   64   65   66   67   68