Office and Technology Applications
Office and Technology Applications asks you to match a task to the right tool and to predict what a feature will do. The exam emphasizes spreadsheets, word processing, presentation graphics, simple databases, collaboration, and file formats rather than memorizing menu locations.
Core rules
- Spreadsheet formulas begin with =; functions use name(arguments), such as =SUM(B2:B10). Relative references (A1) shift when copied; absolute references ($A$1) do not; mixed references lock only the row or column.
- A spreadsheet recalcs automatically when precedent cells change; circular references are errors because a formula depends on its own result.
- Word processing features: styles apply consistent formatting and build navigation; mail merge combines a main document with a data source; track changes records edits; PDF is for fixed-layout distribution, not easy editing.
- Presentation best practice: one idea per slide, readable contrast, alt text for images, and slide notes for detail you do not want on screen.
- Databases store structured records; a query answers a question, a form supports data entry, and a report formats output.
- Collaboration via shared drives or cloud documents raises version-control and permission questions; least privilege means share view-only unless editing is needed.
Worked example
A price list has tax rate in C1. Cells B2:B10 hold prices. You need after-tax prices in D2:D10. Enter =B2*(1+$C$1) in D2 and copy down. B2 is relative, so D3 uses B3. $C$1 is absolute, so every row still points to the tax rate. Copying =B2*(1+C1) without dollar signs would make D3 use C2, an empty cell, producing wrong results. Reasoning: identify what must stay fixed, then lock it.
Traps
- Confusing COUNT (numbers) with COUNTA (nonblank) and COUNTIF (conditional).
- Assuming PDF preserves editability; it preserves layout.
- Treating mail merge as copy-and-paste; it requires a data source with matching field names.
- Choosing a chart type that hides the pattern: pie charts for parts of one whole, line charts for trends over time, bar charts for comparisons.
- Forgetting that formulas, not typed results, update when data changes.