Next: Symbolic Operators
Up: Formulas
Previous: Formulas
Data is input to cells in the workspace. When a cell is clicked on, or highlighted, it is said to be selected. To make a cell editable, double-click on it. To select a range, select a cell and drag the mouse over the desired region. The range will be highlighted.
Sharp Tools Spreadsheet allows for user-defined formula input, such as:
=1+54
=B10^(5-2)
=AVERAGE(C1:C10)
=SUM(C2:C7)/2
Sharp Tools Spreadsheet allows nearly arbitrary variable-length parameter input to most formulas using
- literals: -1, 0, 100
- relative addressing: A1, B4, E76
- absolute addressing: $A$2, $B$5, $E$7
- range specification: C1:C10, A2:B2
Next: Symbolic Operators
Up: Formulas
Previous: Formulas
Daniel Medina
2000-12-10