Spreadsheet formats, forumlas and essential shortcuts

Useful spreadsheet shortcut

Control	Function
Ctrl+z	Undo
Ctrl+x	Cut
Ctrl+v	Paste
Ctrl+c	Copy
Shift+Ctrl+arrow	Expand the selection to the last populated cell in the direction of the arrow
=	Indicates the beginning a formula
*	Multiply
/	Divide
+	Add
-	Subtract
Select the top left corner	This will select the whole spreadsheet

Useful spreadsheet formulas

Formula	Function
=sum()	allows you to add values
=max()	find the maximum value
=min()	find the minimum value
=average()	calculate the average of a set of values
=median()	calculate the median of a set of values (the value in the middle ie half the values are lower than the median & half the values are higher than the median)
=mode()	the most commonly occurring value
=count()	counts the number of vaules