| 1. |
Look at the
spreadsheet below.
|
|
|
|
A |
B |
C |
D |
1 |
0.1
|
=A1*2 |
|
|
2 |
0.2
|
|
|
|
3 |
0.1
|
|
|
|
4 |
0.3 |
|
|
|
5 |
0.4 |
|
|
|
6 |
|
|
|
|
7 |
|
|
|
|
8 |
|
|
|
|
|
(1) |
| |
|
|
| |
(a) What formula
would appear in cell A6 if you clicked on the cell and then the
sum tool? |
(1) |
| |
|
|
| |
(b) What would
happen if you clicked on cell A1 and then the currency button? |
(1) |
| |
|
|
| |
(c) What would
happen if you clicked on cell A2 and then the percentage button? |
(1) |
| |
|
|
| |
(d) How do
you change the width of a column? |
(1) |
| |
|
|
| |
(e) How do
you change the height of a row? |
(1) |
| |
|
|
| 2. |
Draw 3 different
types of chart available in a spreadsheet package. |
(3) |
| |
|
|
| 3. |
What is replication? |
(1) |
| |
|
|
| 4. |
What would
the formula be cell B5 if the formula in B1 was copied down to b5? |
(1) |
| |
|
|
| |
Total |
(10) |
