Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem
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.