Integration

Question 7 doesn't teach a new program — it tests whether you can carry a skill from Word, Excel or Access over into a slightly different situation than the one it was first explained in. Each point below is really a Word/Excel skill from the other notes pages, applied across a boundary (between sheets, between files, or between programs) rather than within a single worksheet or document.

Key integration techniques

• Chart from a sheet: rows are categories (sectors) and columns are series (Q1–Q4) when the chart should group by sector with four bars each.
• Lookup between sheets: use Sheet!Range, e.g. Impact!$A$2:$E$6.
• Create one logo from two images: arrange both on a Word page, group or copy them, then save as a PNG picture. Name and save it exactly as asked.
• Mail merge: the finished merged letters open as a new document called "Letters1" which you then Save As.

Chart from a sheet. A clustered column chart always draws one group of bars per category (taken from the first selected column or row) and one coloured bar per series within each group (taken from the remaining columns or rows). When a table has sectors down the side and quarters across the top, Excel's default guess sometimes groups by quarter instead of by sector — the data hasn't changed, only which axis Excel chose to treat as the category. Chart Design → Switch Row/Column doesn't recalculate anything; it simply swaps which direction is treated as categories versus series, which is the fast fix when the chart groups the "wrong" way around.

Lookup between sheets. A formula on one worksheet can reference cells on a different worksheet using SheetName!CellRange — the sheet name and an exclamation mark in front of an ordinary reference, with everything else (relative/absolute, ranges, functions) working exactly as it does within a single sheet. This is the only new piece of syntax needed to make VLOOKUP, SUMIFS or any other function pull data from another tab — once you know a reference can cross a sheet boundary, the function itself behaves identically to the single-sheet version covered in the spreadsheets notes.

Create one logo from two images. Word has no "combine images into one file" command, so the trick is to use Word as scratch space: place both pictures on a page, select them together, and either Group them (which Word treats as one object you can then right-click → Save as Picture) or copy the selection and paste it into any image tool. Either route collapses two separate picture files into a single new image file — which is exactly what the HTML question later needs, since an <img> tag can only point at one file.

Mail merge. Clicking Finish & Merge → Edit Individual Documents doesn't modify the original template letter at all — it generates a brand-new document (conventionally named "Letters1") containing one fully personalised letter per row of the data source, one after another. Because this merged output is a new, unsaved file, the final step of a mail merge question is always a Save As under the exact name given, not an ordinary Save — saving the original template again would just save the template, with its merge fields still unresolved, rather than the finished letters.