Result:
As you can see the information from add new suppliers has been added to the supplier database, so the test is working.
Result:
As you can see the stock item has reached below a stock level of that quantity of four, so it has been highlighted in red.
The screen above shows the the screen above shows If
Sum function by multiplying price by you add all values from
The amount of quantity. H-3 to h18 a total is worked
Out.
Result:
The test is working as a total price is worked out after you add all the sums together.
Results:
I am unable to touch any cell except the quantity sizes and the items sold, as you can see I am only able to put the mouse selection on those data names. So my test is positive and works.
Result: The order sheet is printed out, by clicking on the print macro screen, I have attached a print out of the order sheet.
Result:
The text is easily readable and is in size 10 font, so test number 8 is working.
Result:
Test number 9 is working as I have entered more than 30 letters on item name. So an error message has appeared telling me to re-enter.
Result:
In test 10 when I enter any numerical values on the price column, it will automatically add a pound sign currency to it.
Result:
The validation added means total amount cannot exceed £5000, if the total amount does go over £5000 an error message is shown just as above.
First I typed in a Vlookup function, so it would look up the supplier’s sheet in order to find the phone number.
Result:
As I have shown above when the Vlookup function is used the formula result shows a correct number.