BSBTEC402 Design and produce complex spreadsheets

1. When formatting and designing a spreadsheet, what are five key aspects relating to the presentation and readability of data?
2. Explain the term ergonomics and provide one example of a typical organisational requirement relating to ergonomics in the workplace.
3. If a person is working at a desk for long periods of time, an organisational requirement may be to break every 40 minutes. Explain how a worker can incorporate this into their job design.
4. Identify three typical organisational requirements that would relate to being sustainable in relation to spreadsheet production?
5. Using the table below, identify key aspects of organisational policies and procedures relating to the production of complex spreadsheets.

Organisational policies and procedures	Key aspects in relation to spreadsheet production
Privacy and confidentiality policy
File management procedures
Style guides
Workplace Health and Safety policy and procedures

6. When developing spreadsheets, you will be continually testing the formulae to check for accuracy. Identify two key methods used to carry out testing on a spreadsheet, providing examples to demonstrate your answer.