Office Productivity Software (Word Processing, Spreadsheets, Presentation)
Domain 2: Office Productivity Software
This domain tests practical command over word processing, spreadsheets, and presentation software. Expect questions on formatting, page setup, formulas, cell references, charts, slide transitions, and the difference between saving and exporting. The exam rewards precise menu/command knowledge, not just general awareness.
Core rules and concepts
- Word processing: use styles for headings, page setup for margins/orientation, and mail merge to combine a main document with a data source. Track changes and comments support review.
- Spreadsheets: every formula begins with =. A cell reference such as B2 can be relative (changes when copied), absolute ($B$2, fixed), or mixed ($B2 / B$2). Common functions: SUM, AVERAGE, COUNT, COUNTA, MAX, MIN, IF.
- Charts: column/bar for comparison, line for trend, pie for parts of a whole. Label axes and titles.
- Presentations: a slide master controls consistent fonts and layout; transitions move between slides; animations move objects on a slide. Use Slide Show mode for delivery.
Worked example
Question: In a spreadsheet, C2 contains =B2*$D$1. If copied to C3, what happens? Reasoning: B2 is relative, so it becomes B3. $D$1 is absolute, so it stays $D$1. The copied formula is =B3*$D$1. This is useful when every row multiplies by one fixed rate in D1.
Traps that cost marks
Typing B2*D1 without = gives text, not a calculation. COUNT counts numeric cells; COUNTA counts non-empty cells. A transition is not an animation. Saving as .docx is not the same as exporting to PDF. Do not merge cells unnecessarily-it breaks sorting and filtering.