Page 72 - Web_Application_v2.0_C12_Fb
P. 72

Step 3:  Press the Enter key. You will get the result; the result will be 24.
              The Formula Bar displays the formula entered in the selected cell.



















              Adding Using 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’.

              Here, the output will be 100 that will be displayed in the cell A5 as soon as the ‘Enter’ key is pressed.































              Using Mouse to Select Values

              Using the mouse to select values is a simple and efficient way to create formulas by directly selecting cells
              instead of manually typing their references.
              Perform the following steps to select values using the mouse:
              Step 1:  Click on the cell where you want the result.



                70    Touchpad Web Applications (Ver. 2.0)-XII
   67   68   69   70   71   72   73   74   75   76   77