| 1. |
Name the three
types of data that can be entered in a spreadsheet cell (see spreadsheet
intro page!) |
(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 |
|
| |
|
|
|
|
|
| |
|
|
total = |
17500 |
|
|
|
| |
|
|
| |
Write spreadsheet
formulae to calculate the following: |
|
| |
|
|
| |
(a) Total
amount paid by all students
|
(1) |
| |
(b) Amount
remaining for Edward
|
(1) |
| |
|
|
| |
|
|
| 4. |
What are the
symbols used in spreadsheets for: |
(4) |
| |
(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) |
| |
|
|
| 7 |
what are the individual boxes on a spreadsheet called? |
(1) |
| |
|
|
| 8 |
how do you identify each one of the individual boxes?
total |
(1)
(15) |
