| 1. |
What is
the correct name for the text that appears exactly the same on
all letters of a mail merge document.
|
(1) |
| |
|
|
| 2. |
Describe
what is meant by variables in mailmerge? |
(1) |
| |
|
|
| 3. |
What type
of linkage is used in mailmerge and why? |
(2) |
|
|
|
| 4. |
List the
steps involved in creating a mailmerge document |
(4) |
| |
|
|
| 5. |
5. Mhairi
is farmer who breeds cows and then sells them. She uses a spreadsheet
to work out the profit she will earn from each cow. The total
costs for each cow
are calculated automatically using formulae. Part of the spreadsheet
is given below:
|
(1) |
| |
|
(1) |
| |
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
Cow
No. |
|
Feeding
Costs |
Vet
Costs |
Total
Costs |
|
Selling
Price |
|
Profit |
4 |
|
|
|
|
|
|
|
|
|
5 |
GGH123 |
|
105.85 |
34 |
139.85 |
|
285.5 |
|
145.65 |
6 |
GGH142 |
|
95.5 |
0 |
95.5 |
|
155 |
|
59.5 |
7 |
HHH160 |
|
115 |
34 |
149 |
|
265.5 |
|
116.5 |
8 |
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
| |
(a) For
each of the following write down a cell reference of a cell containing
the object: label, value, formula
|
(3) |
| |
|
|
| |
(b) Write
down a formula which uses a function to calculate the total profit
on the three cows shown.
|
(2) |
| |
|
|
| |
(c) Mhairi
changes the value in cell D6 to 34. Name two other cells which
will change.
|
(2) |
| |
|
|
| |
(d) Some
of the entries for the costs, selling price and profit, do not
look like amounts of money. Explain what Mhairi could do to solve
this problem.
|
(2) |
| |
|
|
| |
(e) Cell
I5 contains a formula to calculate the profit for cow number GGH123.
What is this formula ?
|
(1) |
| |
|
|
| |
(f) Cell
I6 and I7 also contain formulae. These formulae were not typed
in at the keyboard. Describe how this could be done. |
(2) |
| |
|
|
| |
Total |
(22) |
