Elements and Performance Criteria
- Create spreadsheets
- Open the spreadsheet application, create spreadsheet files and enter numbers, text and symbols into cells according to information requirements
- Enter simple formulas and functions using cell referencing when required
- Correct formulas when error messages occur
- Use a range of common tools during spreadsheet development
- Edit columns and rows within the spreadsheet
- Use the auto-fill function to increment data where required
- Save the spreadsheet to a folder on a storage device
- Customise basic settings
- Adjust page layout to meet user requirements or special needs
- Open and view different toolbars
- Change font settings so they are appropriate for the document purpose
- Change alignment options and line spacing according to spreadsheet formatting features
- Format cell to display different styles as required
- Modify margin sizes to suit the purpose of the spreadsheets
- View multiple spreadsheets concurrently
- Format spreadsheet
- Use formatting features as required
- Copy selected formatting features from another cell in the spreadsheet or from another active spreadsheet
- Use formatting tools as required within the spreadsheet
- Align information in a selected cell as required
- Insert headers and footers using formatting features
- Save spreadsheet as another file type
- Save to storage device and close spreadsheet
- Incorporate object and chart in spreadsheet
- Print spreadsheet