| 1. |
Name the three
types of data that can be entered in a spreadsheet cell. |
(3) |
| |
|
|
| 2. |
Give two reasons
why accountants would find a spreadsheet program useful? |
(2) |
| |
|
|
| 3. |
Look at
the spreadsheet below.
|
|
|
|
A |
B |
C |
D |
E |
1 |
Name |
Age |
School
Fees |
Amount
Paid |
Amount
Remaining |
2 |
Mary |
12 |
5000 |
3000 |
|
3 |
Tom |
14 |
5200 |
5200 |
|
4 |
Nicola |
15 |
4800 |
4100 |
|
5 |
Ruth |
11 |
5200 |
1600 |
|
6 |
Edward |
13 |
5250 |
3600 |
|
|
(1) |
| |
|
|
| |
Write formulae
to calculate the following: |
|
| |
|
|
| |
(a) Average
age
|
(1) |
| |
(b) Total
amount paid by all students
|
(1) |
| |
(c) Amount
remaining for Edward
|
(1) |
| |
|
|
| 4. |
What are the
symbols used in spreadsheets for: |
(2) |
| |
(a) Addition
(b)
Multiplication
(c)
Subtraction
(d)
Division
|
|
| |
|
|
| 5. |
Which symbol
must every formula start with? |
(1) |
| |
|
|
| 6. |
What is the
purpose of entering text in cells? |
(1) |
| |
|
|
| |
Total |
(12) |
