Create and update spreadsheets with data
Overview
This standard is about creating and using spreadsheets to enter and process data.
This involves setting up and formatting worksheets, entering data and saving the spreadsheet file. It includes using spreadsheet features and tools to process and display information and to format and print spreadsheet outputs.
This standard is for those who need to enter and process data using spreadsheet software to meet their own needs or as part of their duties.
Performance criteria
You must be able to:
Agree the data and functionality requirements for a new or existing spreadsheet with stakeholders
Create new worksheets with column and row headings for entering data in line with requirements
Format spreadsheet worksheets, rows, columns and cells to meet requirements
Enter and edit information accurately into spreadsheets
- Use spreadsheet tools and techniques to summarise and display required information
- Use standard functions and formulae to meet calculation requirements
- Test and debug spreadsheets to verify that they operate in line with requirements
- Select and use appropriate page layout to present spreadsheet information required
- Save and retrieve slpreadsheets into appropriate shared or local repositaries in line with organisational standards
Knowledge and Understanding
You need to know and understand:
- Identify what information is needed to be organised and stored in the spreadsheet application
- How to create a new spreadsheet
- How to enter and display the required information should be structured to meet needs
- How to use standard formulae and tools to display and organise spreadsheet information
- How to produce straightforward spreadsheets
- How to format cells, rows and columns including alignment
- How to set and format number types and the number of decimal places,
- How to select font style
- How to add borders and shading to spreadsheets
- How to use tools and techniques to present spreadsheet information
- How to enter, edit and organise numerical information in a spreadsheet
- The standard formulae and functions used to manage data in spreadsheets
- The basic features of spreadsheet components (including, cells, rows, columns, tabs, and pages or worksheets
- How to setup the layout of a spreadsheet to meet needs
- How to check spreadsheet information is accurate and correct
- How to store and retrieve spreadsheet files