Detailed · Deep study
1Display features and formatting
| Feature | Notes |
|---|---|
| formulae or values view | show the formulae (e.g. for evidence) or the results |
| row height / column width | adjust so that all data, labels and formulae are fully visible (no ##### or cut-off text) |
| wrap text | long text continues on a new line inside the cell |
| hide/display rows and columns | hide working columns without deleting them |
| enhancements | text colour, cell colour, bold, underline, italic, shading |
| number formats | number of decimal places, currency symbols (e.g. $, €, KSh), percentages |
| conditional formatting | changes the format of a cell depending on its contents, e.g. red fill if a value is below 50 |
2Page layout
- Set the orientation to portrait or landscape.
- Fit the printout to a specified number of pages (e.g. 1 page wide).
- Set a print area to print only part of the sheet.
- Display or hide gridlines and row and column headings on the printout.
3Exam focus
Key words: formulae view; column width; wrap text; hide; conditional formatting; print area; gridlines; row and column headings.
Quick self-check
Answer in your head first, then reveal.
Changes the format of a cell (1) depending on its value/contents (1).
Any two: formulae view; widen columns; fit to one page; landscape; show row/column headings (2).
