Testing

= Spreadsheet Testing =

You need to test all formulas and functions, you need to make sure that all possible paths in the spreadsheet are tested.

 * ==== What you are testing ==== || ==== What you will enter ====

(this needs to be exact)
|| ==== Which cell you will enter the value ==== || ==== What the expected result is ====

(exactly what you expect to happen)
|| ==== Did it pass the test? ==== || ==== Have you made ====

any changes?
||
 * //(examples shown below)// ||  ||   ||   ||   ||   ||
 * If the total cost of food for all staff is correct || 25 || Cell E23 || Cell F40 shows £8400 || Yes || none needed ||

You will be marked on

 * ===the test plan,===
 * ===how many of the formulas and functions you have tested.===
 * ===Marks will not be deducted for having found errors in your spreadsheet.===
 * ===Marks will be given for correctly identifying and correcting errors.===