Spreadsheets

ecdl-logo

Spreadsheets

This module allows candidates to understand the concept of spreadsheets and to demonstrate an ability to use a spreadsheet to produce accurate work outputs.

On completion of this module the candidate will be able to:

  • Work with spreadsheets and save them in different file formats.
  • Choose built-in options, such as the Help function, within the application to enhance productivity.
  • Enter data into cells; use good practice in creating lists.
  • Select, sort and copy, move and delete data. Edit rows and columns in a worksheet.
  • Copy, move, delete, and appropriately rename worksheets.
  • Create mathematical and logical formulas using standard spreadsheet functions; use good practice in formula creation; recognise error values in formulas.
  • Format numbers and text content in a spreadsheet.
  • Choose, create, and format charts to communicate information meaningfully.
  • Adjust spreadsheet page settings.
  • Check and correct spreadsheet content before finally printing spreadsheets.
ECDL TEST.

A 45 minute online test to be completed by the Candidate.
To Pass, a result of 75% or greater is needed.
Result is delivered after completion of the test.
Test Certificate is received within 1 week.