Develop and Produce Complex Spreadsheets Assignment
10 Pages2070 Words105 Views
Added on 2021-02-20
Develop and Produce Complex Spreadsheets Assignment
Added on 2021-02-20
ShareRelated Documents
Develop and producecomplex spreadsheets
Table of ContentsActivity 1A.......................................................................................................................................1Injuries which may take place while working at a computer for long periods of time andergonomic improvements to reduce the risk of injury.................................................................1Examples of ergonomic requirements to apply within organisation...........................................1Activity 1B.......................................................................................................................................1Reason for undertaking task analysis and outlining what a task analysis might involve............1Simple task analysis.....................................................................................................................2Outlining spreadsheet specifications involves and application of this to the examplespreadsheet used above................................................................................................................2Activity 1C.......................................................................................................................................2Identification examples of different elements..............................................................................2Activity 1D.......................................................................................................................................3Creation of a mind map of all potential problem areas in terms of energy and resources usedwithin workplace..........................................................................................................................3Activity 2A.......................................................................................................................................3Using an example spreadsheet and identification spreadsheet features it contain.......................3Example of different functions to develop the spreadsheets.......................................................3Selection of one of the example functions and the way in which it could be used.....................3Different formulas which were used while developing spreadsheets..........................................3Selection of one of the formula and details regarding use of it...................................................3Activity 2B.......................................................................................................................................4Meaning of link spread sheets and outlining the steps to link spreadsheets................................4Three reasons for linking the spreadsheets..................................................................................4Creation of example spreadsheet in excel and completion of linking process............................4Activity 2C.......................................................................................................................................6Different ways of formatting the cells.........................................................................................6Difference between relative and absolute cell reference.............................................................6Creation of simple spreadsheet that relates to the organisation...................................................6Activity 2D.......................................................................................................................................6
Examples of different ways in which formulas could be checked in spreadsheets.....................6Examples of different errors that may come across.....................................................................6Selection of two example errors and reason behind them and the way in which it could befixed.............................................................................................................................................7
End of preview
Want to access all the pages? Upload your documents or become a member.