Page 228 - IT_Play_V1.0 Class9
P. 228

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


                          The ‘fx’ button is used to enter or edit formula. When the data is typed in a cell, two buttons
                          appear after the ‘fx’ button, i.e., Cross Mark 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. ‘AutoSum’ button is used to calculate the sum of specified range of cells.




                FORMULA

              A formula is a mathematical expression that performs calculations using values, cell references, and operators.
              One of the most important features of a spreadsheet package is the ability to perform calculations, for which
              formulas are used. Formulas are entered to carry out mathematical operations such as addition, subtraction,
              multiplication, and division. Entering a formula in a cell is a logical entry that shows the relationship between
              different cells. In LibreOffice Calc or Excel, a formula always starts with an equal (=) sign. The formula applied

              in a particular cell can be viewed in the formula bar when the specific cell is selected.
              Formulas in Calc include the following:

              Formula with Cell Address

              Each cell in the sheet has a unique address that is formed by the intersection of its column and row, such
              as ‘A10’. Here, ‘A’ is the column name and ‘10’ is the row number. Formulas are applied to cells on the basis

              of the cell address that displays the output as a result of calculation done between data of different cell
              addresses. Suppose, the data entered in cells A1, A2, A3 and A4 are 5, 15, 20 and 60 respectively. In cell A5, a
              formula is entered to calculate the sum of these numbers with their cell address; thus it will be displayed as
              ‘=A1+A2+A3+A4’.



                226     Information Technology Play (Ver 1.0)-IX
   223   224   225   226   227   228   229   230   231   232   233