Office and Productivity Software: Revision and References
Shared revision, practice questions, answer explanations and references from the original module.
By Akhilesh Saini
Module quick-revision sheet
| Area | Core idea | Frequent exam distinction |
|---|---|---|
| Word processing | Documents, editing and page layout | Editing versus formatting |
| Mail merge | Main document + recipient data | Not the same as replace-all |
| Spreadsheet | Workbook → worksheets → cells | Workbook versus worksheet |
| Excel address | Column letter + row number | B3 is column B, row 3 |
| Formula | Usually starts with = | Cell value versus displayed format |
| Basic calculation | SUM, AVERAGE, COUNT, COUNTA, IF | Numeric COUNT versus nonempty COUNTA |
| References | Relative A1, absolute $A$1, mixed $A1 / A$1 | Fixed row versus fixed column |
| Presentation | Slides, layouts and themes | Animation versus transition |
| Modern Office trio | .docx, .xlsx, .pptx | .docm, .xlsm, .pptm permit macros |
| Shortcut families | Copy, cut, paste; save, print; undo, redo | App/platform context affects behaviour |
| Page setup | Paper, margins, orientation, scaling | Landscape versus different paper size |
| Printing | Range, copies, duplex and collate | Duplex versus copies; collated versus uncollated |
Five mini-scenarios for final recall
- A list contains amounts and missing entries. SUM adds numeric amounts; COUNT counts numeric cells; COUNTA counts nonempty cells. Choose the function based on what the question actually asks.
- A repeated letter needs personalised names. Use mail merge, not a stack of manually copied documents.
- An Excel formula's reference must keep a tax-rate cell unchanged when copied. Use an absolute reference such as
$E$1. - A presentation shows a chart appearing inside a slide and then moves to the next slide. The first effect is an animation; the second is a transition.
- A report prints pages in the order
1,2,3,1,2,3for two copies. The print run is collated.
Sources & further reading
These authoritative references support the Office terminology, common workflows and extension distinctions used in the lessons. The explanations and original exam-style questions in this module have been written for Computer Awareness rather than reproduced from the reference pages.
- Microsoft Support — Use mail merge to personalise letters — main document, recipient list and merge fields.
- Microsoft Support — Switch between relative and absolute references — relative, mixed and absolute cell references.
- Microsoft Support — Excel formula tips and tricks — formula entry and reference-switching conventions.
- Microsoft Support — The difference between animations and transitions — effects on slide objects versus effects between slides.
- Microsoft Support — Open XML formats and file name extensions — DOCX, XLSX, PPTX and macro-enabled families.
- Microsoft Support — File formats supported in Excel — workbook, CSV and other formats.
- Microsoft Support — File formats supported in PowerPoint — presentation, slideshow and export formats.
- Microsoft Support — Common file name extensions in Windows — common document and media extensions.