Context
Task 1
Task 2
Task 3
Task 4
Task 5
Task 6
Task 7
Task 8
Task 9
|
Resource
Sheet 13
Testing the spreadsheet
When you test a
spreadsheet you have to use data that you can calculate, so keep it simple!
The idea of testing is to make sure your formulae work properly otherwise your answers
will be useless.
GIGO (Garbage in - Garbage out)
Once you have tested your
sheet print it off and record what you did to test it. You may want to use a table like
the one below.
| The test
data I used |
What I
expected to happen |
Did it
happen? |
Any changes
needed? |
| I inputted
300 into each income cell |
I expected
the formula to add it up to 300 |
Yes |
None |
| I inputted
10 into each expenditure cell in column B |
I expected
the formula to add it up to 180 |
No |
I needed to
re-do the formula because I put add instead of multiply - once changed it worked. |
Timed Practical Task 
Home
|