summaryrefslogtreecommitdiff
path: root/help/sheetqt/enterdata.html
blob: 08962244566c10681f5bead5d54ee5e06119fc8d (plain)
1
2
3
4
5
6
7
8
9
10
11
<html><head><title>Opie Sheet Help</title></head><body>
<h2> Entering Formulas</h2>
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:
<ol type="1">
<li>Click the cell, which will show the result.</li>
<li>Click the <img src="equal.png"> button.</li>
<li>Select Average function from the Statistical menu, which will appear when you click the <img src="function.png"> button.</li>
<li>Activate the Cell Selector by clicking the <img src="cellselect.png"> button, press on the cell A1 and release on the cell B3.</li>
<li>Click the <img src="paran.png"> button.</li>
<li>Click the <img src="accept.png"> button.</li>
</ol></body></html>