The Basic Tab for the Spreadsheet Activity allows authors to specify
a title for the activity, create Learner instructions, and defines the
questions that will make up each record:
Title: All Activities have a web page title which is
presented at the top of the activity page when displayed in the
Learning Environment. This is NOT the same title as the Title that can be set using the Properties Inspector.Instructions:
All Activities have a text area that is presented beneath the title.
This is where the main activity text to be displayed to learners is
entered. The text can be formatted using the RichText Editor. Image,
Video, Audio and URL content can also be displayed in the Instructions
area.
Specific Feature: Spreadsheet Applet
The Spreadsheet is where the data and calculations for the activity
are entered. The Applet contains a comprehensive help menu, which is
accessed by clicking Help in the topright corner of the applet, and is reproduced here.
 You may also like to read the Simple Groupware manual available here. 
Some of the most useful spreadsheet functions are listed below:
Spreadsheet Functions
The Spreadsheet can be viewed in one of several modes. These are
changed by clicking the labels in the topright corner of the applet.
Values: shows all the calculated values on the screen (default mode)
Auto: calculates and updates values in real timeManual: Disables automatic calculations (gives better performance)
Click Refresh to update the values in the spreadsheet if Manual mode is selected.
Formulas: shows the formulas in the spreadsheet.
Formulas: shows all formulas on the screen
Styles: shows all styles on the screen
Cell References
A1 gives the value of cell A1A2:A4 gives the values of A2, A3 and A4 in an array[A2,A4] gives the values A2 and A4 in an array.
NOTE: Cell values are always given using capital letters. ie: a1 will not give the value of cell A1.
Maths Formulae
For addition of a row: sum(A2:A4) gives A2+A3+A4For addition across columns: sum(A2:B3) gives A2+A3+B2+B3For averages: avg(2,3,4) gives (2+3+4)/3 = 3For minimum values: min(2,3,4) gives 2 (the smallest value in the array)For maximum values: max(2,3,4) gives 4 (the largest value in the array)For number of values: count(A2:A4) gives 3 (the number of values in the array)
Keyboard shortcuts
enter / start typing
edit cell
ctrl+x or shift+del
cut cell
ctrl+c or ctrl+ins
copy cell
ctrl+v or shift+ins
paste cell
del
empty cell
cursor up
go up
cursor down
go down
cursor left
go left
cursor right
go right
home
go to first cell in row or page left/up if already in first cell
end
go to last cell in row or page right if already in last cell
page up
go 10 rows down
page down
go 10 rows up
Additional functions and commands can be found here.
