Logged out
Access All our Essays in an Instant
Swap your work for FREE access, or pay £4.99 for instant access
Spreadsheet testing
Member rating: No Rating | Words: | Submitted: Mon Mar 21 2005
Page Preview
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
Cell Descriptions Expected Actual result D5-11 Add up figure from column d-l, the figure 1 represents signing in figure 0 represent signing out. Expected result is between 1 and 9 depending on how many ones there are in the signing table. The actual result will be a total of all the ones in the sign in table. E.g. 1+1+1=3 D5-11 Data validation of the cells so only 0 or 1 can be entered. Expected result is going to be 1 or 0 Actual result will be 1 if the employee is in and 0 if the employee is not in. C4-11 Drop down list consisting of six duties. Expected result will be one of the six duties place in the drop down list. E.g. till or lunch. Actual result will be either TILL C/R LUNCH TEA BREAK GAP ADD STOCK PHOTO T D6-11 Conditional formatting. This consists of to colours red and black. Red stands for the extreme data entries, entered in the work performance table....
Get instant access
- Instant, unlimited access to our documents in full
- Swap your work for free access, or pay £4.99
- To see the full version of this document and 149,410 others
