Office Productivity Software (Word Processing, Spreadsheets, Presentation)
This domain tests practical use of the three office tools: word processing, spreadsheets, and presentations. Questions often ask which command to use, what a copied formula will do, or how to deliver a slide show cleanly.
Word processing
- Styles apply consistent fonts, spacing, and headings; they also feed the navigation pane and table of contents.
- Mail merge combines a main document with a data source to produce personalized letters, labels, or envelopes.
- Track Changes records insertions, deletions, and comments for review; accepting or rejecting them finalizes the document.
- Headers, footers, page numbers, margins, orientation, and section breaks control page layout.
Spreadsheets
- A cell reference such as A1 can be relative (changes when copied), absolute ($A$1, locked), or mixed ($A1 or A$1).
- Every formula begins with =. Functions include SUM, AVERAGE, COUNT, MAX, MIN, and IF.
- A chart should match the data: column for comparison, line for trend, pie for parts of a whole.
Presentations
- The slide master controls consistent layout and formatting across slides.
- A transition is between slides; an animation is within a slide. Do not mix these terms.
Worked example
A price list has a tax rate in B2 (18%) and a price in C2. D2 contains =C2*(1+$B$2). With C2=500, D2 shows 590. Copy D2 to D3: the formula becomes =C3*(1+$B$2), because the dollar signs lock B2. If the formula had been =C2*(1+B2), copying to D3 would read B3, probably blank, and give a wrong total. Reasoning: identify which reference must stay fixed before filling down.
Traps that cost marks
SUM(A1:A5) totals the range; SUM(A1,A5) totals only two cells. Text beginning with = is read as a formula; prefix an apostrophe to keep it as text. A transition is not an animation. Mail merge needs a data source; retyping names is not a merge.