• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Spreadsheet testing

Extracts from this document...

Introduction

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. ...read more.

Middle

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. 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. ...read more.

Conclusion

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-15 T 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 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work