Application Packages and Productivity Tools
This domain covers using ready-made packages competently. The exam tests word-processing features, spreadsheet formulas and functions, charts, presentations and file formats, usually through practical scenarios.
Word processing
Use styles for headings so a table of contents can be generated automatically. Mail merge combines a main document with a data source to personalise many copies. Headers and footers repeat on every printed page; track changes and comments support review; templates enforce consistent layout.
Spreadsheets
A formula begins with = and uses + − * / ^. Relative references such as A1 change when copied; absolute references such as $A$1 stay fixed; mixed references ($A1, A$1) lock one part only. Functions: SUM, AVERAGE, MAX, MIN, COUNT (numeric cells only), COUNTA (all non-empty cells), IF(test, value_if_true, value_if_false), VLOOKUP, ROUND. Charts: pie for parts of a whole, column or bar for comparison, line for trends over time, scatter for correlation.
Worked example
A mark sheet holds student totals in B2:B21 and the class total in B22. To show each student's percentage in C2: =B2/$B$22*100. The $ signs lock row and column, so when the formula is copied to C21 it still divides by B22. If B2 is 34 and B22 is 200, the result is 17 (percent). Without the $ signs, copying down would divide by B23, B24 and so on, producing wrong values or #DIV/0!.
Traps that cost marks
- Copying a formula and forgetting which references should be absolute.
- Using COUNT when non-empty text cells must be included - that is COUNTA.
- Choosing a pie chart when categories overlap or do not form a whole.
- Leaving numbers stored as text, so SUM silently ignores them.
- Assuming a file will look identical on another computer without checking fonts and version compatibility.