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. This independent chapter covers spreadsheets, word processing, presentation design, simple databases, collaboration and file formats without asserting an official target blueprint or product-version interface.
Core rules
- Spreadsheet formulas begin with =; functions use name(arguments), such as =SUM(B 2:B 10). Relative references (A 1) shift when copied; absolute references ($A$1) do not; mixed references lock only the row or column.
- In automatic calculation mode, a spreadsheet updates dependent formulas when precedent values change. Manual calculation settings differ. Circular references can indicate an unintended dependency, but some applications permit explicitly configured iterative models; do not assume every cycle is always an error.
- 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 designed for fixed-layout distribution; editing is possible with suitable tools, while the source document is usually more useful for structural revision.
- 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 C 1. Cells B 2:B 10 hold prices. You need after-tax prices in D 2:D 10. Enter =B 2*(1+$C$1) in D 2 and copy down. B 2 is relative, so D 3 uses B 3. $C$1 is absolute, so every row still points to the tax rate. Copying =B 2*(1+C 1) without dollar signs would make D 3 use C 2, 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 a fixed-layout PDF necessarily preserves all editable source-document structure; actual capabilities depend on the file and tool.
- 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.