The Currency Converter - Some Questions
Here’s a picture of a finished currency converter for the USA
Questions (answer in the spaces below the question…
On the layout and appearance of the converter
1. Is pink a suitable colour for cell A1? What colour would you have chosen and why?
2. Why have some cells been formatted to currency?
3. Give a clear explanation of how you would you have improved the layout of the screen.
4. Why has cell D13 been highlighted in red?
5. Why did the designer of the system need to keep the screen-size compact/small?
On testing
1. What evidence is there to show that the currency converter is working?
2. Why did the person testing the system put simple numbers like “1” into column C?
On locking the screen
1. Why did the person making the system think it was a good idea to lock some of the cells?
On the overall system
1. Do you think a traveller would make use of this system?
2. Suggest TWO improvements that could be made to the system
Here’s a picture of a finished currency converter for the USA showing
formulas
Questions
1. What does the formula in cell D13 do?
2. Why does the formula in cell D13 been written using “sum” rather than just putting
D8+D9+D10+D11+D12?
3. What is the reason for writing $C$5 instead of C5 in cell D8?
4. The special name for describing the use of the dollar ($) in this situation is called
A------ Cell Ref-------- (fill in the blanks)
Now add your name in the footer and print off this doument!