Spreadsheet testing

D5-11Data 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-11Drop 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 eitherTILL C/RLUNCHTEA BREAKGAPADD STOCKPHOTO T D6-11Conditional formatting. This consists of to colours red and black. Red stands for the extreme data entries, entered in the work performance table. Extreme data is numbers 1,2,3 and 8,9 and 10. The normal data is 4,5,6 and 7.Actual result will be 1,2,3 and 8,9 and 10 in red and 4,5,6 and 7 in black.  D6-11The Spinner control a series of numbers between 1 and 10 When controlling the spinner the expected out will be between the numbers 1-10The actual result will be 1,2,3,4,5,6,7,8,9,10. Depending on the employees performanceH12- 30Macros are assigned to a command button. The macros link the button to the different sheets in the spreadsheet. The expected result will be the one of the buttons leading to one of the sheets.Actual result will be a link between the command button and the sheet. E.g. sign in button to sheet 2.G2-15T auto sum function is an automatic addition sum. It takes a total of all the number in the adjacent columns of the same row. Expected result will be the totals of the numbers in the work performance table. Actual result will be a total of the number in the work performance table. E.g. 4+3+5+7=19 Spreadsheet testing Correction                   Data validation test Conational formatting