Syllabus V5.0

SYLLABUS V5.O CORE LEVEL ICDL

The European Computer Driving Licence Foundation Ltd.
Third Floor, Portview House Thorncastle Street Dublin 4 Ireland

Tel: + 353 1 630 6000
Fax: + 353 1 630 6001

E-mail: info@ecdl.com, URL: www.ecdl.com
The official version of ECDL / ICDL Syllabus Version 5.0 is the version published on the ECDL Foundation Web site, which can be found at: www.ecdl.com

Disclaimer
Although every care has been taken by the ECDL Foundation in the preparation of this publication, no warranty is given by the ECDL Foundation as publisher as to the completeness of the information contained within it and neither shall the ECDL Foundation be responsible or liable for any errors, omissions, inaccuracies, loss or damage whatsoever arising by virtue of such information or any instructions or advice contained within this publication. As stated above, the information may not be reproduced in whole or part without permission and acknowledgement. Changes may be made by the ECDL Foundation at its own discretion and at any time without notice.

Copyright © 2007 The ECDL Foundation Ltd.
All rights reserved. No part of this publication may be reproduced in any form except as permitted by the European Computer Driving Licence (ECDL) Foundation Copyright © 2007 The ECDL Foundation Ltd. Ref: ECDL / ICDL – Syllabus – V5.0 . Enquiries for permission to reproduce material should be directed to the publisher.

CONTENTS
Module 1 – Concepts of Information and Communication Technology (ICT)
Module 2 – Using the Computer and Managing Files
Module 3 – Word Processing
Module 4 – Spreadsheets
Module 5 – Using Databases
Module 6 – Presentation
Module 7 – Web Browsing and Communication

Module 1 – Concepts of Information and Communication Technology (ICT)

The following is the Syllabus for Module 1, Concepts of Information and Communication Technology (ICT), which provides the basis for the theory-based test in this module.

Module Goals:

Module 1 Concepts of Information and Communication Technology (ICT)

Rrequires the candidate to understand the main concepts of ICT at a general level, and to know about the different parts of a computer.
Copyright © 2007 The ECDL Foundation Ltd. Ref: ECDL / ICDL – Syllabus – V5.0 Page 2 of 37

The candidate shall be able to:
• Understand what hardware is, know about factors that affect computer performance and know about peripheral devices.
• Understand what software is and give examples of common applications software and operating system software.
• Understand how information networks are used within computing, and be aware of the different options to connect to the Internet.
• Understand what Information and Communication Technology (ICT) is and give examples of its practical applications in everyday life.
• Understand health and safety and environmental issues in relation to using computers.
• Recognize important security issues associated with using computers.
• Recognize important legal issues in relation to copyright and data protection associated with using computers.

CATEGORY - KNOWLEDGE AREA - REF. - KNOWLEDGE ITEM

1.1 Hardware
1.1.1 Concepts

1.1.1.1 Understand the term hardware.
1.1.1.2 Understand what a personal computer is. Distinguish between desktop, laptop (notebook), tablet PC in terms of typical users.
1.1.1.3 Identify common handheld portable digital devices like: personal digital assistant (PDA), mobile phone, smartphone, multimedia player and know their main features.
1.1.1.4 Know the main parts of a computer like: central processing unit (CPU), types of memory, hard disk, common input and output devices.
1.1.1.5 Identify common input/output ports like: USB, serial, parallel, network port, FireWire.

1.1.2 Computer Performance
1.1.2.1 Know some of the factors that impact on a computer’s performance like: CPU speed, RAM size, graphics card processor and memory, the number of
applications running.
1.1.2.2 Know that the speed (operating frequency) of the CPU is measured in megahertz (MHz) or gigahertz (GHz).
1.1.3 Memory and Storage

1.1.3.1 Know what computer memory is: RAM (random-access memory), ROM (readonly memory) and distinguish between them.
1.1.3.2 Know storage capacity measurements: bit, byte, KB, MB, GB, TB.
1.1.3.3 Know the main types of storage media like: internal hard disk, external hard disk, network drive, CD, DVD, USB flash drive, memory card, online file
storage.
1.1.4 Input, Output Devices

1.1.4.1 Identify some of the main input devices like: mouse, keyboard, trackball, scanner, touchpad, stylus, joystick,
web camera (webcam), digital camera, microphone.
1.1.4.2 Know some of the main output devices like: screens/monitors, printers, speakers, headphones.
1.1.4.3 Understand some devices are both input and output devices like: touchscreens.

1.2 Software
1.2.1 Concepts

1.2.1.1 Understand the term software.
1.2.1.2 Understand what an operating system is and name some common operating systems.
1.2.1.3 Identify and know the uses of some common software applications: word processing, spreadsheet, database, presentation, e-mail, web browsing, photo editing, computer games.
1.2.1.4 Distinguish between operating systems software and applications software.
1.2.1.5 Know some options available for enhancing accessibility like: voice recognition software, screen reader, screen magnifier, on-screen keyboard.

1.3 Networks
1.3.1 Network Types

1.3.1.1 Understand the terms local area network (LAN), wireless local area network (WLAN), wide area network (WAN).
1.3.1.2 Understand the term client/server.
1.3.1.3 Understand what the Internet is and know some of its main uses.
1.3.1.4 Understand what an intranet, extranet is.
1.3.2 Data Transfer

1.3.2.1 Understand the concepts of downloading from, uploading to a network.
1.3.2.2 Understand what transfer rate means. Understand how it is measured: bits per second (bps), kilobits per second (kbps), megabits per second (mbps).
1.3.2.3 Know about different Internet connection services: dial-up, broadband.
1.3.2.4 Know about different options for connecting to the Internet like: phone line, mobile phone, cable, wireless, satellite.
1.3.2.5 Understand some of the characteristics of broadband: always on, typically a flat fee, high speed, higher risk of intruder attack.

1.4 ICT in Everyday Life
1.4.1 Electronic World

1.4.1.1 Understand the term Information and Communication Technology (ICT).

1.4.1.2 Know about different Internet services for consumers like: e-commerce, ebanking, e-government.
1.4.1.3 Understand the term e-learning. Know some of its features like: flexible learning time, flexible learning location, multimedia learning experience, cost effectiveness.
1.4.1.4 Understand the term teleworking. Know some of the advantages of teleworking like: reduced or no commuting time, greater ability to focus on one task, flexible schedules, reduced company space requirements. Know some disadvantages of teleworking like: lack of human contact, less emphasis on teamwork.

1.4.2 Communication

1.4.2.1 Understand the term electronic mail (email).
1.4.2.2 Understand the term instant messaging (IM).
1.4.2.3 Understand the term Voice over Internet Protocol (VoIP).
1.4.2.4 Understand the term Really Simple Syndication (RSS) feed.
1.4.2.5 Understand the term web log (blog).

1.4.2.6 Understand the term podcast.
1.4.3 Virtual Communities

1.4.3.1 Understand the concept of an online (virtual) community. Recognize examples like: social networking websites, Internet forums, chat rooms, online computer games.
1.4.3.2 Know ways that users can publish and share content online: web log (blog), podcast, photos, video and audio clips.
1.4.3.3 Know the importance of taking precautions when using online communities: make your profile private, limit the amount of personal information you post, be aware that posted information is publicly available, be wary of strangers.
1.4.4 Health

1.4.4.1 Understand the term ergonomics.
1.4.4.2 Recognize that lighting is a health factor in computer use. Be aware that use of artificial light, amount of light, direction of light are all important considerations.
1.4.4.3 Understand that correct positioning of the computer, desk and seat can help maintain a good posture.
1.4.4.4 Recognize ways to help ensure a user’s wellbeing while using a computer like: take regular stretches, have breaks, use eye relaxation techniques.
1.4.5 Environment

1.4.5.1 Know about the option of recycling computer components, printer cartridges and paper.

1.4.5.2 Know about computer energy saving options: applying settings to automatically turn off the screen/monitor, to automatically put the computer to sleep, switching off the computer.

1.5 Security
1.5.1 Identity/Authentication

1.5.1.1 Understand that for security reasons a user name (ID) and password are needed for users to identify themselves when logging on to a computer.
1.5.1.2 Know about good password policies like: not sharing passwords, changing them regularly, adequate password length, adequate letter and number
mix.
1.5.2 Data Security

1.5.2.1 Understand the importance of having an off-site backup copy of files.

1.5.2.2 Understand what a firewall is.
1.5.2.3 Know ways to prevent data theft like: using a user name and password, locking computer and hardware using a security cable.
1.5.3 Viruses

1.5.3.1 Understand the term computer virus.
1.5.3.2 Be aware how viruses can enter a computer system. 1.5.3.3 Know how to protect against viruses and the importance of updating antivirus software regularly.

1.6 Law
1.6.1 Copyright

1.6.1.1 Understand the term copyright.
1.6.1.2 Know how to recognize licensed software: by checking product ID, product registration, by viewing the software licence.
1.6.1.3 Understand the term end-user license agreement.
1.6.1.4 Understand the terms shareware, freeware, open source.

1.6.2 Data Protection

1.6.2.1 Identify the main purposes of data protection legislation or conventions: to protect the rights of the data subject, to
set out the responsibilities of the data controller.
1.6.2.2 Identify the main data protection rights for a data subject in your country.

1.6.2.3 Identify the main data protection responsibilities for a data controller in your country.

Module 2 – Using the Computer and Managing Files

The following is the Syllabus for Module 2, Using the Computer and Managing Files, which provides the basis for the theory and practice-based test in this module.

Module Goals
Module 2 Using the Computer and Managing Files requires the candidate to demonstrate.

Competence in running and managing a personal computer. The candidate shall be able to:
• Use the main features of the operating system including adjusting the main computer settings and using built-in help features.
• Operate effectively around the computer desktop and work effectively in a graphical user environment.
• Know about the main concepts of file management and be able to efficiently organize files and folders so that they are easy to identify and find.
• Use utility software to compress and extract large files and use anti-virus software to protect against computer viruses.
• Demonstrate the ability to use simple text editing and print tools available within the operating system.

CATEGORY - SKILL SET - REF. - TASK ITEM

2.1 Operating System

2.1.1 First Steps

2.1.1.1 Start the computer and log on securely using a user name and password.
2.1.1.2 Restart the computer using an appropriate routine.
2.1.1.3 Shut down a non-responding application.
2.1.1.4 Shut down the computer using an appropriate routine.
2.1.1.5 Use available Help functions.

2.1.2 Setup

2.1.2.1 View the computer’s basic system information: operating system name and version number, installed RAM (random- access memory).
2.1.2.2 Change the computer’s desktop configuration: date & time, volume settings, desktop display options (colour settings, desktop background, screen pixel resolution, screen saver options).

2.1.2.3 Set, add keyboard language.
2.1.2.4 Install, uninstall a software application.

2.1.2.5 Use keyboard print screen facility to capture a full screen, active window.

2.1.3 Working with Icons

2.1.3.1 Identify common icons like those representing: files, folders, applications, printers, drives, recycle bin/wastebasket/trash.

2.1.3.2 Select and move icons.

2.1.3.3 Create, remove a desktop shortcut icon, make an alias.
2.1.3.4 Use an icon to open a file, folder, application.

2.1.4 Using Windows 2.1.4.1 Identify the different parts of a window: title bar, menu bar, toolbar or ribbon, status bar, scroll bar.

2.1.4.2 Collapse, expand, restore, resize, move, close a window.

2.1.4.3 Switch between open windows.

2.2 File Management
2.2.1 Main Concepts 2.2.1.1 Understand how an operating system organizes drives, folders, files in a hierarchical structure.

2.2.1.2 Know devices used by an operating system to store files and folders like: hard disk, network drives, USB flash drive, CD-RW, DVD-RW.

2.2.1.3 Know how files, folders are measured: KB, MB, GB.

2.2.1.4 Understand the purpose of regularly backing up data to a removable storage device for off-site storage.

2.2.1.5 Understand the benefits of online file storage: convenient access, ability to share files.

2.2.2 Files and Folders

2.2.2.1 Open a window to display folder name, size, location on a drive.
2.2.2.2 Expand, collapse views of drives, folders.
2.2.2.3 Navigate to a folder, file on a drive.

2.2.2.4 Create a folder and a further subfolder.

2.2.3 Working with Files

2.2.3.1 Identify common file types: word processing files, spreadsheet files, database files, presentation files, portable document format files, image files, audio files, video files, compressed files, temporary files, executable files.
2.2.3.2 Open a text editing application. Enter text into a file, name and save the file to a location on a drive.
2.2.3.3 Change file status: read-only/locked, read-write.
2.2.3.4 Sort files in ascending, descending order by name, size, type, date modified.
2.2.3.5 Recognize good practice in folder, file naming: use meaningful names for folders and files to help with recall and organization.
2.2.3.6 Rename files, folders.

2.2.4 Copy, Move

2.2.4.1 Select a file, folder individually or as a group of adjacent, non-adjacent files, folders.
2.2.4.2 Copy files, folders between folders and between drives.
2.2.4.3 Move files, folders between folders and between drives.

2.2.5 Delete, Restore

2.2.5.1 Delete files, folders to the recycle bin/wastebasket/trash.
2.2.5.2 Restore files, folders from the recycle bin/wastebasket/trash.
2.2.5.3 Empty the recycle bin/wastebasket/trash.

2.2.6 Searching 2.2.6.1 Use the Find tool to locate a file, folder.
2.2.6.2 Search for files by all or part of file name, by content.
2.2.6.3 Search for files by date modified, by date created, by size.

2.2.6.4 Search for files by using wildcards: file type, first letter of file name.
2.2.6.5 View list of recently used files.

2.3 Utilities

2.3.1 File Compression

2.3.1.1 Understand what file compression means.
2.3.1.2 Compress files in a folder on a drive.
2.3.1.3 Extract compressed files from a location on a drive.

2.3.2 Anti-Virus

2.3.2.1 Understand what a virus is and the ways a virus can be transmitted onto a computer.
2.3.2.2 Use anti-virus software to scan specific drives, folders, files.
2.3.2.3 Understand why anti-virus software needs to be updated regularly.

2.4 Print Management

2.4.1 Printer Options

2.4.1.1 Change the default printer from an installed printer list.
2.4.1.2 Install a new printer on the computer.

2.4.2 Print

2.4.2.1 Print a document from a text editing application.
2.4.2.2 View a print job’s progress in a queue using a desktop print manager.
2.4.2.3 Pause, re-start, delete a print job using a desktop print manager.

Module 3 – Word Processing

The following is the Syllabus for Module 3, Word Processing, which provides the basis for the practice-based test in this module.

Module Goals
Module 3 Word Processing requires the candidate to demonstrate the ability to use a word processing application to create everyday letters and documents.

The candidate shall be able to:
• Work with documents and save them in different file formats.
• Choose built-in options such as the Help function to enhance productivity.
• Create and edit small-sized word processing documents that will be ready to share and distribute.
• Apply different formats to documents to enhance them before distribution and recognize good practice in choosing the appropriate formatting options.
• Insert tables, images and drawn objects into documents.
• Prepare documents for mail merge operations.
• Adjust document page settings and check and correct spelling before finally printing documents.

CATEGORY SKILL - SET - REF. - TASK ITEM

3.1 Using the Application
3.1.1 Working with Documents
3.1.1.1 Open, close a word processing application. Open, close documents.
3.1.1.2 Create a new document based on default template, other available template like: memo, fax, agenda.
3.1.1.3 Save a document to a location on a drive. Save a document under another name to a location on a drive.
3.1.1.4 Save a document as another file type like: text file, Rich Text Format, template, software specific file extension, version number.
3.1.1.5 Switch between open documents.

3.1.2 Enhancing Productivity

3.1.2.1 Set basic options/preferences in the application: user name, default folder to open, save documents.
3.1.2.2 Use available Help functions.

3.1.2.3 Use magnification/zoom tools.
3.1.2.4 Display, hide built-in toolbars. Restore, minimize the ribbon.

3.2 Document Creation

3.2.1 Enter Text 3.2.1.1 Switch between page view modes.
3.2.1.2 Enter text into a document.
3.2.1.3 Insert symbols or special characters like: ©, ®, ™.

3.2.2 Select, Edit

3.2.2.1 Display, hide non-printing formatting marks like: spaces, paragraph marks, manual line break marks, tab characters.
3.2.2.2 Select character, word, line, sentence, paragraph, entire body text.
3.2.2.3 Edit content by entering, removing characters, words within existing text, by over-typing to replace existing text.
3.2.2.4 Use a simple search command for a specific word, phrase.
3.2.2.5 Use a simple replace command for a specific word, phrase.
3.2.2.6 Copy, move text within a document, between open documents.
3.2.2.7 Delete text.
3.2.2.8 Use the undo, redo command.

3.3 Formatting

3.3.1 Text

3.3.1.1 Change text formatting: font sizes, font types.
3.3.1.2 Apply text formatting: bold, italic, underline.
3.3.1.3 Apply text formatting: subscript, superscript.
3.3.1.4 Apply different colours to text.
3.3.1.5 Apply case changes to text.
3.3.1.6 Apply automatic hyphenation.

3.3.2 Paragraphs

3.3.2.1 Create, merge paragraph(s).

3.3.2.2 Insert, remove soft carriage return (line break).
3.3.2.3 Recognize good practice in aligning text: use align, indent, tab tools rather than inserting spaces.
3.3.2.4 Align text left, centre, right, justified.
3.3.2.5 Indent paragraphs: left, right, first line.
3.3.2.6 Set, remove and use tabs: left, centre, right, decimal.
3.3.2.7 Recognize good practice in paragraph spacing: apply spacing between paragraphs rather than use the Return key.
3.3.2.8 Apply spacing above, below paragraphs. Apply single, 1.5 lines, double line spacing within paragraphs.
3.3.2.9 Add, remove bullets, numbers in a single level list. Switch between different standard bullet, number styles in a single level list.
3.3.2.10 Add a box border and shading/background colour to a paragraph.

3.3.3 Styles

3.3.3.1 Apply an existing character style to selected text.
3.3.3.2 Apply an existing paragraph style to one or more paragraphs.
3.3.3.3 Use copy format tool.

3.4 Objects

3.4.1 Table Creation 3.4.1.1 Create a table ready for data insertion.
3.4.1.2 Insert, edit data in a table.
3.4.1.3 Select rows, columns, cells, entire table.
3.4.1.4 Insert, delete, rows and columns.

3.4.2 Table Formatting 3.4.2.1 Modify column width, row height.
3.4.2.2 Modify cell border line style, width, colour.

3.4.2.3 Add shading/background colour to cells.
3.4.3 Graphical Objects 3.4.3.1 Insert an object (picture, image, chart, drawn object) to a specified location in a document.
3.4.3.2 Select an object.
3.4.3.3 Copy, move an object within a document, between open documents.
3.4.3.4 Resize, delete an object.

3.5 Mail Merge

3.5.1 Preparation

3.5.1.1 Open, prepare a document, as a main document for a mail merge.
3.5.1.2 Select a mailing list, other data file, for use in a mail merge.
3.5.1.3 Insert data fields in a mail merge main document (letter, address labels).

3.5.2 Outputs

3.5.2.1 Merge a mailing list with a letter, label document as a new file or printed output.
3.5.2.2 Print mail merge outputs: letters, labels.
3.6 Prepare Outputs

3.6.1 Setup

3.6.1.1 Change document orientation: portrait, landscape. Change paper size.
3.6.1.2 Change margins of entire document, top, bottom, left, right.
3.6.1.3 Recognize good practice in adding new pages: insert a page break rather than using the Return key.
3.6.1.4 Insert, delete a page break in a document.
3.6.1.5 Add, edit text in headers, footers.
3.6.1.6 Add fields in headers, footers: date, page number information, file name.
3.6.1.7 Apply automatic page numbering to a document.

3.6.2 Check and Print

3.6.2.1 Spell check a document and make changes like: correcting spelling errors, deleting repeated words.

3.6.2.2 Add words to a built-in custom dictionary using a spell checker.
3.6.2.3 Preview a document.
3.6.2.4 Print a document from an installed printer using output options like: entire document, specific pages, number of copies.

Module 4 – Spreadsheets
The following is the Syllabus for Module 4, Spreadsheets, which provides the basis for the practice-based test in this module.

Module Goals
Module 4 Spreadsheets requires the candidate to understand the concept of spreadsheets and to demonstrate an ability to use a spreadsheet to produce accurate work outputs.

The candidate shall 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 and 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 and recognize 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 and check and correct spreadsheet content before finally printing spreadsheets.

CATEGORY - SKILL - SET REF. - TASK ITEM

4.1 Using the Application

4.1.1 Working with Spreadsheets
4.1.1.1 Open, close a spreadsheet application. Open, close spreadsheets.
4.1.1.2 Create a new spreadsheet based on default template.
4.1.1.3 Save a spreadsheet to a location on a drive. Save a spreadsheet under another name to a location on a drive.
4.1.1.4 Save a spreadsheet as another file type like: template, text file, software specific file extension, version number.
4.1.1.5 Switch between open spreadsheets.

4.1.2 Enhancing Productivity

4.1.2.1 Set basic options/preferences in the application: user name, default folder to open, save spreadsheets.
4.1.2.2 Use available Help functions.
4.1.2.3 Use magnification/zoom tools.
4.1.2.4 Display, hide built-in toolbars. Restore, minimize the ribbon.

4.2 Cells

4.2.1 Insert, Select 4.2.1.1 Understand that a cell in a worksheet should contain only one element of data, (for example, first name detail in one cell, surname detail in adjacent cell).
4.2.1.2 Recognize good practice in creating lists: avoid blank rows and columns in the main body of list, insert blank row before Total row, ensure cells
bordering list are blank.
4.2.1.3 Enter a number, date, text in a cell.
4.2.1.4 Select a cell, range of adjacent cells, range of non-adjacent cells, entire worksheet.

4.2.2 Edit, Sort

4.2.2.1 Edit cell content, modify existing cell content.
4.2.2.2 Use the undo, redo command.
4.2.2.3 Use the search command for specific content in a worksheet.
4.2.2.4 Use the replace command for specific content in a worksheet.
4.2.2.5 Sort a cell range by one criterion in ascending, descending numeric order, ascending, descending alphabetic order.

4.2.3 Copy, Move, Delete

4.2.3.1 Copy the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets.
4.2.3.2 Use the autofill tool/copy handle tool to copy, increment data entries.
4.2.3.3 Move the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets.

4.2.3.4 Delete cell contents.

4.3 Managing Worksheets

4.3.1 Rows and Columns

4.3.1.1 Select a row, range of adjacent rows, range of non-adjacent rows.
4.3.1.2 Select a column, range of adjacent columns, range of non-adjacent columns.
4.3.1.3 Insert, delete rows and columns.
4.3.1.4 Modify column widths, row heights to a specified value, to optimal width or height.
4.3.1.5 Freeze, unfreeze row and/or column titles.

4.3.2 Worksheets

4.3.2.1 Switch between worksheets.
4.3.2.2 Insert a new worksheet, delete a worksheet.
4.3.2.3 Recognize good practice in naming worksheets: use meaningful worksheet names rather than accept default names.
4.3.2.4 Copy, move, rename a worksheet within a spreadsheet.

4.4 Formulas and Functions

4.4.1 Arithmetic Formulas

4.4.1.1 Recognize good practice in formula creation: refer to cell references rather than type numbers into formulas.
4.4.1.2 Create formulas using cell references and arithmetic operators (addition, subtraction, multiplication, division).
4.4.1.3 Identify and understand standard error values associated with using formulas: #NAME?, #DIV/0!, #REF!.
4.4.1.4 Understand and use relative, absolute cell referencing in formulas.

4.4.2 Functions

4.4.2.1 Use sum, average, minimum, maximum, count, counta, round functions.
4.4.2.2 Use the logical function if (yielding one of two specific values) with comparison operator: =, >, <.

4.5 Formatting

4.5.1 Numbers/Dates

4.5.1.1 Format cells to display numbers to a specific number of decimal places, to display numbers with, without a separator to indicate thousands.
4.5.1.2 Format cells to display a date style, to display a currency symbol.
4.5.1.3 Format cells to display numbers as percentages.

4.5.2 Contents

4.5.2.1 Change cell content appearance: font sizes, font types.
4.5.2.2 Apply formatting to cell contents: bold, italic, underline, double underline.
4.5.2.3 Apply different colours to cell content, cell background.
4.5.2.4 Copy the formatting from a cell, cell range to another cell, cell range.

4.5.3 Alignment, Border Effects
4.5.3.1 Apply text wrapping to contents within a cell, cell range.
4.5.3.2 Align cell contents: horizontally, vertically. Adjust cell content orientation.
4.5.3.3 Merge cells and centre a title in a merged cell.
4.5.3.4 Add border effects to a cell, cell range: lines, colours.

4.6 Charts

4.6.1 Create

4.6.1.1 Create different types of charts from spreadsheet data: column chart, bar chart, line chart, pie chart.
4.6.1.2 Select a chart.
4.6.1.3 Change the chart type.
4.6.1.4 Move, resize, delete a chart.

4.6.2 Edit

4.6.2.1 Add, remove, edit a chart title.
4.6.2.2 Add data labels to a chart: values/numbers, percentages.
4.6.2.3 Change chart area background colour, legend fill colour.
4.6.2.4 Change the column, bar, line, pie slice colours in the chart.

4.6.2.5 Change font size and colour of chart title, chart axes, chart legend text.

4.7 Prepare Outputs

4.7.1 Setup

4.7.1.1 Change worksheet margins: top, bottom, left, right.
4.7.1.2 Change worksheet orientation: portrait, landscape. Change paper size.
4.7.1.3 Adjust page setup to fit worksheet contents on a specified number of pages.
4.7.1.4 Add, edit, delete text in headers, footers in a worksheet.
4.7.1.5 Insert and delete fields: page numbering information, date, time, file name, worksheet name into headers, footers.

4.7.2 Check and Print

4.7.2.1 Check and correct spreadsheet calculations and text.
4.7.2.2 Turn on, off display of gridlines, display of row and column headings for printing purposes.
4.7.2.3 Apply automatic title row(s) printing on every page of a printed worksheet.
4.7.2.4 Preview a worksheet.
4.7.2.5 Print a selected cell range from a worksheet, an entire worksheet, number of copies of a worksheet, the entire spreadsheet, a selected chart.