Function	Arguments	Example	Result	Additional Information	Sample #	Sample Text
ABS	numbers_as_array	"=ABS(F4)"	62		23	Hello World
AVERAGE	values_as_array	"=AVERAGE(F4:F14)"	46.92307692307692	Synonym:?AVG	45	True
CEILING	numbers_as_array	"=CEILING(F4:F14)"	62108200361799100		62	False
COUNT	html_as_string	"=COUNT(F2:F14)"	13		108	To High
DAYSFROM	url_as_string	"=DAYSFROM(2009,4,15)"	70		200	To Low
DOLLAR	numbers_as_array	"=DOLLAR(F13)"	$55.00		36	Perfect
FALSE		"=IF(F4 < 100, TRUE(), FALSE())"	TRUE		17	number
FIXED	number, decimals, noCommas?	"=FIXED(F4+F14)"	41.00	Two decimal places	99	numbers_as_array
FLOOR	numbers_as_array	"=FLOOR(F4-F5)"	-46	Synonym: INT	100	values_as_array
HYPERLINK		"=HYPERLINK("http://www.jquery.com", "jQuery website")"	jQuery website		-100	html_as_string
IF	IF(logical_test, value_if_true, value_if_false)	"=IF(F12 < 100, TRUE(), FALSE())"	TRUE	Can have nested IF functions.	-14	url_as_string
IMG		"=IMG("http://ui.jquery.com/images/logo.gif")"		The url can be sensitive to numbers. Also, on initial load, because the image doesn't really have a size, the outerheight can be distorted. An easy way to offset this is to have some text in front of it that's taller than the image :).	55	values
MAX	values_as_array	"=MAX(F3:F13)"	200		-21
MIN	values_as_array	"=MIN(F3:F13)"	-100
N	numbers_as_array	"=N(F3)"	45
PI		"=PI()"	3.141592653589793	If you use "=PI" it will return the actual function as text, which is incorrect. Use "=PI()".
TODAY		"=TODAY()"	Tue Jun 08 2010 17:02:55 GMT-0400 (Eastern Daylight Time)
TRUE		"=TRUE() || FALSE()"	TRUE
SUM	values_as_array	"=SUM(F2:F13)"	631
ROUND	numbers_as_array	"=ROUND(1.6)"	2
RAND		"=RAND()"	0.14401618065909916	Synonym: RND
Advanced Functionality		Example	Result	Additional Information
Direct Javascript		"=jQuery.sheet.version"		The character '=' simply starts a reference to javascript. The example here interacts with the jS (or jQuery.sheet) object and calls a function that returns it's current version.
Math.PI		"=Math.PI"	3.141592653589793	The Math function here is actually the javascript Math function. So in a since, you are writing javascript from the sheet.

Cell Navigation	Result
Left Arrow	Active cell moves left if possible.
Right Arrow	Active cell moves right if possible.
Up Arrow	Active cell moves up if possible.
Down Arrow	Active cell moves down if possible.
Escape	Active cell is removed from focus.
Enter	Starts in-place edit / Active cell moves down if possible.
Shift + Enter	Adds a line break to the cell's value
Ctrl + Enter	Ends in-place edit / Active cell moves down if possible.
Tab	Active cell moves right if possible.
Ctrl + Z	Undo
Ctrl + Y	Redo
Ctrl + Z	Paste, can even past from other spreadsheets!

Feature	Info
jQuery.sheet is Re-sizable!	Click and drag on the cell identification bars, and it will resize the row or column. You may also resize the spreadsheet and formula editor at the top.
Auto Scroll	When you navigate to a cell the spreadsheet pane automatically scrolls to it.
Multi cell select	If you drag your mouse over a range of cells, it will select them for you. You can use this to change their style.
Multi cell select from cell Id bars	Double click on the mouse Id bars and it will select the range of cells associated with it.
Get cell locations	Press shift while selection cells and it will return their location to the formula editor, like (A1, or A1:B4)
Style cells	Cells are styleable.
Single cell reference	Example A1
Range cell reference	Example A1:B4
Range Shifting	This often goes overlooked, but when you insert or delete new rows/columns, the ranges will shift their formula to the new location of the cell(s).
Lockable cell referencing	Fixed cell references won't update when you add or delete rows and columns. Example SHEET1:A1, SHEET1:A1:B4
Fill cell values up
Fill cell values down
Undo and redo