| 1. |
Look at
the spreadsheet below.
|
|
|
|
A |
B |
C |
D |
1 |
Name |
Age |
No
Of Sisters |
No
Of Brothers |
2 |
Jim |
14 |
2 |
1 |
3 |
Dave |
13 |
1 |
2 |
4 |
Ruth |
15 |
0 |
3 |
5 |
Jenna |
14 |
1 |
0 |
6 |
|
|
|
|
7 |
Average
= |
|
|
|
8 |
Total
No Of Siblings = |
|
|
|
|
(1) |
| |
|
|
| |
(a) What
is the value in cell B3? |
(1) |
| |
|
|
| |
(b) Which
type of data is in cell B2? |
(1) |
| |
|
|
| |
(c) What
is the purpose of cell C1? |
(1) |
| |
|
|
| |
(d) What
formula is in cell B7? |
(2) |
| |
|
|
| |
(e) What
formula is in cell B8? |
(2) |
| |
|
|
| |
(f) How
would you fill the formula in cell B7 to cells C7 and D7? |
(1) |
| |
|
|
| |
(g) Describe
an alternative way of filling the formula in cell B7 to cells
C7 and D7. |
(1) |
| |
|
|
| |
(h) How
would you ensure that all the average values are displayed to
2 decimal places? |
(1) |
| |
|
|
| |
Total |
(10) |
