Excel basics
The exam runs on a Windows PC. Windows keys first, Mac keys second.
Moving around
Moving around| What it does | Windows | Mac |
|---|
| Jump to the edge of the data | Ctrl + arrow | ⌘ + arrow |
|---|
| Select to the edge of the data | Ctrl + Shift + arrow | ⌘ + Shift + arrow |
|---|
| Go back to A1 | Ctrl + Home | Fn + Ctrl + ← |
|---|
| Select the whole column | Ctrl + Space | Ctrl + Space |
|---|
| Select the whole row | Shift + Space | Shift + Space |
|---|
| Go to a cell by address | Ctrl + G | Ctrl + G |
|---|
Writing formulas
Writing formulas| What it does | Windows | Mac |
|---|
| Edit the cell in placeDouble-clicking the cell works on both machines. | F2 | Ctrl + U |
|---|
| New line inside a cell | Alt + Enter | ⌥ + ⌘ + Enter |
|---|
Cycle $ on a referenceWith the reference selected inside the formula: B6 → $B$6 → B$6 → $B6. | F4 | ⌘ + T |
|---|
| Show the value of part of a formulaSelect the part first. Press Esc to leave the formula unchanged. | F9 | F9 |
|---|
| Recalculate the workbook | F9 | ⌘ + = |
|---|
| Confirm as an array formula | Ctrl + Shift + Enter | Ctrl + Shift + Return |
|---|
| Show formulas instead of values | Ctrl + ` | Ctrl + ` |
|---|
Filling and copying
Filling and copying| What it does | Windows | Mac |
|---|
| Fill down | Ctrl + D | ⌘ + D |
|---|
| Fill right | Ctrl + R | ⌘ + R |
|---|
| Paste values only | Ctrl + Alt + V, then V | Ctrl + ⌘ + V |
|---|
| Repeat the last action | F4 | ⌘ + Y |
|---|
| Undo | Ctrl + Z | ⌘ + Z |
|---|
Numbers and layout
Numbers and layout| What it does | Windows | Mac |
|---|
| Two decimal places | Ctrl + Shift + 1 | Ctrl + Shift + 1 |
|---|
| Percentage | Ctrl + Shift + 5 | Ctrl + Shift + 5 |
|---|
| Insert rows or columns | Ctrl + Shift + = | Ctrl + Shift + = |
|---|
| Open Format Cells | Ctrl + 1 | ⌘ + 1 |
|---|
| Insert a chart from the selection | Alt + F1 | Fn + F11 |
|---|
Differences you will meet on exam day (Windows)
Practised on a Mac, sitting at a PC. These are the keys that move.
Differences you will meet on exam day (Windows)| What it does | Windows | Mac |
|---|
| Cycle $ on a reference | F4 | ⌘ + T |
|---|
| Edit the cell in place | F2 | Ctrl + U |
|---|
| Recalculate the workbook | F9 | ⌘ + = |
|---|
| Reach the ribbon from the keyboard | Alt shows key tips | No key tips; use the menu bar |
|---|
| Open the right-click menu | Shift + F10 | Ctrl + click |
|---|
| Find Data Analysis | Data tab, far right | Data tab, after Solver |
|---|
| Insert a chart from the selection | Alt + F1 | Fn + F11 |
|---|
Turning on Solver and the Analysis ToolPak
Windows- File → Options → Add-ins
- At the bottom, set Manage: Excel Add-ins, then press Go
- Tick Solver Add-in and Analysis ToolPak, then press OK
- Both now sit on the Data tab: Solver at the right, Data Analysis beside it
Mac- Tools → Excel Add-ins
- Tick Solver Add-in and Analysis ToolPak, then press OK
- Both now sit on the Data tab: Solver and Data Analysis