Information Technology Certificates of Competence
Assessment Criteria

Spreadsheets


The Candidate can:
  1. open a new spreadsheet
  2. name and save the new spreadsheet
  3. design spreadsheet, use of Columns, Rows, Cells
  4. enter data
  5. use formulae and/or functions
  6. copy and paste data
  7. move or delete data from cells
  8. insert or delete rows and/or columns
  9. change the look of the document by using different formats
  10. produce charts by using the spreadsheet programs, or exporting to another charting program
  11. print out document
Distinction Level only:
  1. demonstrate understanding of DDE
  2. demonstrate understanding of OLE
  3. demonstrate understanding of macros