. analysed/reviewed and checked the task and determined specifications/standards for spreadsheets . utilised spreadsheet design software functions and formulae to identified requirements (used the computer software and its fund to do the job) . linked spreadsheets in accordance with software procedures (connected related spreasheets) formatted cells and used data attributes assigned with relative a absolute cell references, in accordance with the task specification . tested formulae to confirm output meets task requirements (mak sure all the sums add up) . evaluated tasks to identify those where automation would increa efficiency (checking to see if there are better ways of improving spreadsheet by making more shortcut commands) . created, used and edited macros to fulfil the requirements of the and automate spreadsheet operation (checked the shortcut commands properly) entered, checked and amended data in accordance with organisational and task requirements . imported and exported data between compatible spreadsheets a adjusting host documents, in accordance with software and syste procedures . used manuals, user documentation and online help to overcome problems with spreadsheet design and production