# Spreadsheet formats, forumlas and essential shortcuts

#### Useful spreadsheet shortcut&#x20;

<table><thead><tr><th width="269">Control </th><th>Function</th></tr></thead><tbody><tr><td><strong>Ctrl+z</strong> </td><td><strong>Undo</strong></td></tr><tr><td><strong>Ctrl+x</strong> </td><td><strong>Cut</strong></td></tr><tr><td><strong>Ctrl+v</strong> </td><td><strong>Paste</strong></td></tr><tr><td><strong>Ctrl+c</strong> </td><td><strong>Copy</strong></td></tr><tr><td><strong>Shift+Ctrl+arrow</strong> </td><td><strong>Expand the selection to the last populated cell in the direction of the arrow</strong></td></tr><tr><td><strong>=</strong></td><td> <strong>Indicates the beginning a formula</strong></td></tr><tr><td><strong>*</strong> </td><td><strong>Multiply</strong></td></tr><tr><td><strong>/</strong> </td><td><strong>Divide</strong></td></tr><tr><td><strong>+</strong> </td><td><strong>Add</strong></td></tr><tr><td><strong>-</strong></td><td> <strong>Subtract</strong></td></tr><tr><td><strong>Select the top left corner</strong> </td><td><strong>This will select the whole spreadsheet</strong></td></tr></tbody></table>



**Useful spreadsheet formulas**&#x20;

| 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 va**ules**                                                                                                                             |
|                |                                                                                                                                                             |
