PURPOSE OF THE UNIT STANDARD This unit standard is intended for people who need to plan, produce, use and spreadsheets to solve problems using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry. People credited with this unit standard are able to: Prepare and produce a spreadsheet to provide a solution to a given problem. Adjust settings to customise the view and preferences of the spreadsheet application. Work with multiple worksheets. Apply formulae to worksheets to provide alternative solutions to a problem. Apply simple built-in functions of the spreadsheet application to the given problem. Apply formatting to a spreadsheet applicable to the given problem. Use special effects to improve the presentation of the spreadsheet. Evaluate a spreadsheet. The performance of all elements is to a standard that allows for further learning in this area