- Practice
- About 16 min
- 5 practice questions
Checking, printing and mail merge: tasks and exam-style traps
Use spelling tools well, avoid Replace All mistakes, read print page ranges and collation, count sheets, and run a mail merge from start to finish.
If something looks wrong, please tell us.
The last steps before a document leaves your hands are checking and printing, and for letters to many people, mail merge. These are full of small traps: the wrong spelling button, a Replace All that changes too much, a page range read wrongly. Work through each one step by step.
Spelling and grammar
- Press F7 in either program to check the whole document; unknown words also show a red wavy underline as you type.
- Change / Correct replaces this one occurrence; Change All / Correct All replaces every occurrence.
- Ignore Once skips this occurrence only.
- Add to Dictionary stores the word in your custom dictionary, so it is not flagged again in this or later documents. Use it for names such as Sikhora or Bhubaneswar.
- AutoCorrect fixes common slips as you type, for example teh becomes the.
- Check the text's language setting: a document set to English (USA) will flag colour and centre.
Find and Replace traps
Replacing Delhi with New Delhi in a document that already contains New Delhi turns it into New New Delhi, because the Delhi inside New Delhi also matches. Fix: first replace New Delhi with a temporary marker, or use Replace one at a time. Remember also Match case (Ram is not ram) and Whole words only (cat should not change category).
Reading the print dialog
| Page range typed | Pages printed |
|---|---|
| 1-4 | 1, 2, 3, 4 (four pages) |
| 2, 5 | 2 and 5 only (two pages) |
| 1-3, 6 | 1, 2, 3 and 6 (four pages) |
| 2-4, 7-8 | 2, 3, 4, 7, 8 (five pages) |
- Copies prints the chosen pages that many times.
- Collate prints complete sets in order: 1, 2, 3, then 1, 2, 3. Without collating, each page's copies come together: 1, 1, 2, 2, 3, 3.
- Single-sided sheets used = pages printed per copy × copies.
- Print preview first, so a wrong margin or a stray blank page does not waste paper.
Mail merge step by step
- Prepare the data source, for example a spreadsheet whose first row holds field names (Name, Class, Address) and each later row holds one person's record.
- Write the main document: the text that is the same for everyone.
- Connect the main document to the data source (Word: Mailings tab > Select Recipients; Writer: Tools > Mail Merge Wizard, or a registered data source).
- Insert merge fields where personal details go, for example Dear followed by the Name field.
- Preview a few records to check spacing and punctuation.
- Finish: print, or create a new document holding every merged letter, or send by email.
The first row of the spreadsheet is the heading row, not a person. So the number of letters equals the number of rows minus one, unless you filter the records.
Worked example 1: sheets and order
Print pages 2-4, 7 of a report, 3 copies, single-sided. Pages per copy: 2, 3, 4 and 7 = 4 pages. Sheets = 4 × 3 = 12. With Collate on, the order is 2, 3, 4, 7, 2, 3, 4, 7, 2, 3, 4, 7. With Collate off: 2, 2, 2, 3, 3, 3, 4, 4, 4, 7, 7, 7.
Worked example 2: counting merged letters
A spreadsheet has 41 filled rows: one heading row and 40 student rows. A full merge makes 41 − 1 = 40 letters. If the recipients are filtered to show only the 15 students of Class 10, the merge makes 15 letters, one for each selected record.
Hyphen = through, comma = and. Sheets = pages per copy × copies. Collate = complete sets. Letters = selected records, and the heading row is not a record.
Key takeaways
- Add to Dictionary for correct names; Ignore Once only skips one occurrence.
- Before Replace All, ask whether the search text hides inside the replacement or inside longer words.
- Mail merge makes one copy per record of the data source.
Check your understanding
-
1. In the print dialog you type 1-3, 6 as the page range. How many pages will print for one copy?
- 4
- 6
- 3
- 5
Show answer
Answer: A. 1-3 means pages 1, 2 and 3, and the comma adds page 6: 3 + 1 = 4 pages. Pages 4 and 5 are skipped.
-
2. A document already contains the words New Delhi in several places. You Replace All Delhi with New Delhi. What do those places now read?
- Delhi
- New Delhi
- Delhi New
- New New Delhi
Show answer
Answer: D. The Delhi inside New Delhi also matches and is replaced by New Delhi, so the text becomes New New Delhi. Replace one at a time or protect New Delhi first.
-
3. You print 3 copies of a 2-page letter with Collate switched on. In which order do the pages come out?
- 1, 1, 1, 2, 2, 2
- 1, 2, 1, 2, 1, 2
- 2, 1, 2, 1, 2, 1
- 1, 2 only
Show answer
Answer: B. Collate prints complete sets in page order, one set after another: 1, 2, then 1, 2, then 1, 2. Without collating, all copies of page 1 come first.
-
4. A mail merge data source has 51 filled rows, the first of which holds the field names. If every record is merged, how many letters are produced?
- 51
- 1
- 50
- 52
Show answer
Answer: C. The first row holds headings, not a person, so there are 51 − 1 = 50 records and 50 letters.
-
5. The spelling check keeps flagging your organisation's correct name, Sikhora, in every document. Which choice stops this in future documents too?
- Ignore Once
- Add to Dictionary
- Change
- Change All
Show answer
Answer: B. Add to Dictionary stores the word in the custom dictionary, so it is accepted from then on. Ignore Once skips one occurrence, and Change or Change All would replace the correct name with a suggestion.
Sign in to keep track of the lessons you finish.