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 |
Last updated