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

