Entering Formulas
For example, to calculate average of the cells in the range A1:B3, you must enter the data as '=AVG(A1,B3)' (without quotes). And it can be done without using any keyboard by using the following procedure:
- Click the cell, which will show the result.
- Click the button.
- Select Average function from the Statistical menu, which will appear when you click the button.
- Activate the Cell Selector by clicking the button, press on the cell A1 and release on the cell B3.
- Click the button.
- Click the button.