20 Does the spread sheet have It should be able to stop I will test the software by password protection any changes from being assigning a password to a made and ask for a spreadsheet and password to change the prohibiting the changes sheet that can be made to it. 21 Does the spread sheet close The spread sheet will I will test the software by when asked to. close down when the closing down the spread correct button is pressed sheet when I have finished and I have saved the work. 22 Does the software perform the It should add up certain I will be adding the correct calculations for example numbers when the appropriate calculation addition calculation is added into into the right cell and a certain cell then checking is it done the sum correctly 23 Does the software preform the It should subtract certain I will be adding the correct calculations for example numbers when the appropriate calculation subtraction calculation is into a into the cell and certain cell then checking is it done the sum correctly 24 Does the software preform the It should multiply certain I will be adding the correct calculations for example numbers when the appropriate calculation multiplication calculation is added into into the right cell and a certain cell then checking is it done the sum correctly 25 Does the software preform the It should divide certain I will be adding the correct calculations for example numbers when the appropriate calculation division calculation is added into into the right cell and a certain cell then checking is it done the sum correctly 26 Can you make a chart/graph out It should take all my data I will be of all the data and put it into a or a highlighting some graph specific data and making it into a chart or graph and then putting the chart or graph on a different sheet. 27 Can you make a table out of all It should take all my data I will be highlighting the data and put it into a table some specific data and making it into a table and putting it on a different sheet. 28 Does the conditional formatting It should show a certain I will be assigning a work for example more than colours when the certain colour for more amount shown in the cell than example orange or is more than a specific to a whole range of number cells to make it easier to see who has made more than their target 29 Does the conditional formatting It should show a certain I will be assigning a work for example less than colours when the certain colour for
20 Does the spread sheet have password protection It should be able to stop any changes from being made and ask for a password to change the sheet I will test the software by assigning a password to a spreadsheet and prohibiting the changes that can be made to it. 21 Does the spread sheet close when asked to. The spread sheet will close down when the correct button is pressed I will test the software by closing down the spread sheet when I have finished and I have saved the work. 22 Does the software perform the correct calculations for example addition It should add up certain numbers when the calculation is added into a certain cell I will be adding the appropriate calculation into the right cell and then checking is it done the sum correctly 23 Does the software preform the correct calculations for example subtraction It should subtract certain numbers when the calculation is into a certain cell I will be adding the appropriate calculation into the cell and then checking is it done the sum correctly 24 Does the software preform the correct calculations for example multiplication It should multiply certain numbers when the calculation is added into a certain cell I will be adding the appropriate calculation into the right cell and then checking is it done the sum correctly 25 Does the software preform the correct calculations for example division It should divide certain numbers when the calculation is added into a certain cell I will be adding the appropriate calculation into the right cell and then checking is it done the sum correctly 26 Can you make a chart/graph out of all the data It should take all my data and put it into a or a graph I will be highlighting some specific data and making it into a chart or graph and then putting the chart or graph on a different sheet. 27 Can you make a table out of all the data It should take all my data and put it into a table I will be highlighting some specific data and making it into a table and putting it on a different sheet. 28 Does the conditional formatting work for example more than It should show a certain colours when the amount shown in the cell is more than a specific number I will be assigning a certain colour for more than example orange or to a whole range of cells to make it easier to see who has made more than their target 29 Does the conditional formatting work for example less than It should show a certain colours when the I will be assigning a certain colour for
OCR%20GCSE%20ICT%20Unit%20B062.docx