The following is part of a household budget spreadsheet. Cells B9 and B14 contain formulas. The
owner wishes to test the spreadsheet which must follow the following rules:
• No individual outgoings can be greater than $100
• The balance can be negative or positive
|
A
|
B
|
C
|
1
|
Household budget
|
|
2
|
|
|
|
3
|
Outgoings
|
|
|
4
|
Heating
|
$45.00
|
|
5
|
Food
|
$80.00
|
|
6
|
Travel
|
$35.00
|
|
7
|
Utilities
|
$61.00
|
|
8
|
Clothes
|
$40.00
|
|
9
|
|
$261.00
|
|
10
|
Income
|
|
|
11
|
Total Salary
|
$280.00
|
|
12
|
|
|
|
13
|
|
|
|
14
|
Balance
|
$19.00
|
|
15
|
|
|
|
Describe four testing strategies you could use to test the model.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................
4 ................................................................................................................................................
...................................................................................................................................................