ecdl exams online , ecdl modules, ecdl tests, ecdl advanced, ecdl online tests, ecdl sample tests, ecdl courses, ecdl qualification, icdl questions, icdl practice, icdl tests, icdl preparation, icdl exams, practise, practice tests, Test, word, powerpoint, sample, questions, practice, testing, exam, tests, samples, driving license, international computer driving licence, ecdl test simulator, ecdl online testing, ecdl module sample questions, icdl exams online, icdl online exams, teste ecdl online
Search
Showing posts with label ECDL Syllabus five Contents. Show all posts
Showing posts with label ECDL Syllabus five Contents. Show all posts
Thursday, February 10, 2011
Sunday, January 16, 2011
ICDL ECDL 1800 Practice Questions VER 5 Office 2007
ICDL ECDL 1800 Practice Questions VER 5 Office 2007
Practice Questions for ECDL 5 using Microsoft Office 2007
ICDL ECDL 1800 Practice Questions VER 5 Office 2003
ICDL ECDL 1800 Practice Questions VER 5 Office 2003
Practice Questions for ECDL 5 using Microsoft Office 2003
ICDL ECDL Standard ver 5 Standard ECDL Advanced 2.0
ICDL ECDL Standard ver 5 Standard ECDL Advanced 2.0
Approved by ECDL Malta
English Language Version
Approved by ICDL South Africa
Standard ECDL 5
Standard ECDL Advanced 2.0
Approved by UNESCO for Egypt ICDL
Standard ECDL 5
Standard ECDL Advanced 2.0
Approved by ICDL Australia
Standard ECDL 5
Standard ECDL Advanced 2.0
Approved by ICDL New Zealand
Standard ECDL 5
Standard ECDL Advanced 2.0
Approved by UNESCO and suitable for Jordan,
Lebanon, Libya, Palestine, Sudan, Syria & Yemen
Standard ECDL 5
Standard ECDL Advanced 2.0
Downlad PDF Sample Files
Tuesday, March 30, 2010
ICDL ECDL Module 7 Syllabus 5.0
ICDL ECDL Module 7 Syllabus 5.0
ICDL ECDL Courseware Outline
ICDL ECDL Courseware Training Materials for IT Trainers
The Microsoft Information And Communication 2007 Screen
INTERNET TERMINOLOGY AND CONCEPTS
World Wide Web (WWW) vs. the Internet
URL (Uniform Resource Locator)
Hyperlinks
ISP (Internet Service Provider)
Web sites and URLs
Structure of a Web Address
Web Browser
Podcasts
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
USING INTERNET EXPLORER
Opening the Microsoft Internet Explorer program
Entering a URL into the Address Bar
Minimizing, maximizing, restoring and closing icons
Zoom
Hyperlinks
Navigating through Web sites
Back and Forward buttons
Forcing a Web page to display within a new window
Forcing a Web page to display within a new tab
Switching between tabs
Quick Tabs
Tab List
Closing a tab
Stop button
Refreshing Web pages
Really Simple Syndication (RSS) feeds
Internet Explorer icons
Copying a picture from a Web site page
Saving a picture on a Web page as a picture file
Copying a Web address (URL) to a document
Saving a Web page
Downloading files from a Web page
Adobe Acrobat files
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
SEARCHING THE WEB
Search Engines
Searching using Instant Search
Searching using the Address Bar
Adding new search engines
Temporarily changing the search engine
Changing the default search engine
Using keywords and phrases
Don't use a single search word!
Searching using specific words
Searching using an exact phrase
Searching by excluding a word(s)
Searching by date
Searching by file format
Online encyclopaedias
Online dictionaries
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
GETTING HELP WITHIN INTERNET EXPLORER
Displaying Help
Help Demos
Browsing for Help
Printing Help sheets
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
CUSTOMIZING INTERNET EXPLORER
Setting your Home Page (stating page)
Visiting the Home Page
Setting multiple Home Pages
Revisiting Web pages via the address bar
Displaying your viewing history
Deleting a history item
Deleting the entire browsing history and temporary files
Customizing history options
Internet cache
Emptying the cache and deleting temporary Internet files
Adding a Web page to your favourites
Opening a favourite (bookmark)
Creating a new favourites folder
Moving a favourite to a folder
Renaming a bookmark
Deleting a bookmark
Adding a Web page to a specified bookmark folder
Deleting a favourites folder
Toolbars
Disabling picture display
Setting your default browser
Installing Add-ons
FEEDS
What are feeds?
Viewing Web pages containing feeds
Subscribing to feeds
Viewing subscribed feeds
Unsubscribing from Feeds
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
SECURITY ISSUES
Internet security & password logons
Risks associated with online activity
Parental control options
Submitting & resetting Web based forms
Protected sites
Digital certificates
Encryption
Secure web sites and https
Viruses & Virus checkers
Malware & Spyware
Worms & Trojans
Spam
Fraud
Firewall
Pop-Up blocking
Turing off popup blocking
Cookies
Information Bar
Phishing Filter
Parental Filtering
Windows Update
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
INTERNET EXPLORER - PRINTING ISSUES
Previewing Web pages
Page Setup - Orientation, paper size and page margins
Printing the entire Web page
Printing a selected area on a Web page
Printing specific page(s)
Printing a number of copies
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
A FIRST LOOK AT OUTLOOK
Starting Outlook
The Microsoft Outlook Screen
Help and Outlook Demos
Printing help sheets
Microsoft Outlook Navigation Pane
Microsoft Outlook Standard Toolbar
Displaying or hiding toolbars
Quick way of displaying / hiding toolbars
Closing Outlook
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
TERMINOLOGY & CONCEPTS
The structure of an email address
The advantages of using email
Netiquette
Spam or Unsolicited Email
Viruses
Phishing
Digital signatures
SMS (short message service)
Voice over Internet Protocol (VoIP)
Benefits of VoIP
Instant messaging (IM)
Benefits of IM
Online (virtual) communities
Social networking websites
Internet forums
Chat rooms
Online computer games
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
SENDING MESSAGES
Creating and sending your first email
Checking that your email was sent
Sending emails to more than one person at a time
Receiving emails
Sending a copy of a message to another address
What is a blind carbon copy?
Using blind carbon copy
Setting the message subject
Spell checking your message
Attaching a file to a message
Removing an inserted file from an email
Issues when sending file attachments
Setting message importance (message priority)
Setting message sensitivity
Saving a draft copy of an e-mail
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
RECEIVING, READING AND REPLYING TO MESSAGES
The Inbox Folder
Opening the Inbox folder
The Inbox Screen
Selecting a message
Message Status icons
Reading a message
Switching between open Message windows
Forwarding a message
Opening or saving an attached file
Replying to the sender of a message
Replying to the sender and all recipients of a message
Setting message reply options so that the original message is inserted, or not inserted
Printing a message
Previewing a message before printing
Printing Options
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
MANIPULATING TEXT AND FILES
Selecting a word within the Message window
Selecting a line within the Message window
Selecting a paragraph within the Message window
Selecting all text within the Message window
Selecting text using the mouse
Copying text to the Clipboard from a message
Pasting text from the Clipboard into a message
Copying text from one message to another
Cutting text to the Clipboard from a message
Moving text from one message to another
Copying text from another application into a message
Deleting text in a message
Deleting text to the left of the insertion point
Deleting text to the right of the insertion point
Deleting an attached file from a message
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
CONTACTS
What are contacts?
Opening the Contacts folder
Creating a contact
Adding the sender of a message to contacts
Addressing an email to a contact
Deleting a contact
What is a distribution list?
Creating a new distribution list
Adding an email address to a distribution list
Removing an email address from a distribution list
Sending an email to a distribution list
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
ORGANISING MAIL
Searching for a message
Searching for messages by sender, subject or content
Creating a new mail folder
Moving a message to a different folder
Deleting a mail folder
Sorting the contents of the Inbox
Deleting a message
Opening the ‘Deleted Items’ folder
Restoring a message from the ‘Deleted Items’ folder
Emptying the ‘Deleted Items’ folder
Automatically emptying the ‘Deleted Items’ folder when you exit Outlook
Flagging a message
Removing a flag mark from a mail message
Identifying an e-mail as read, unread
Marking a message as unread
Marking a message as read
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
CUSTOMISING SETTINGS
Adding an Inbox heading
Removing an Inbox heading
Resetting the Inbox headings
ICDL ECDL Module 7 Syllabus 5.0
The Microsoft Information And Communication 2007 Screen
check back soon there are more topics
ICDL ECDL Module 6 Syllabus 5.0
ICDL ECDL Module 6 Syllabus 5.0
ICDL ECDL Courseware Outline
ICDL ECDL Courseware Training Materials for IT Trainers
THE MICROSOFT PowerPoint 2007 SCREEN
FIRST STEPS WITH PRESENTATIONS
Opening PowerPoint
Opening a presentation
Navigating between slides
Using the Zoom tool
Changing PowerPoint views
Using Help
Saving a presentation
Closing a presentation
Closing PowerPoint
Opening multiple presentations
Switching between multiple presentations
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
CREATING A PRESENTATION
Creating a new presentation
Inserting a new slide
Good Practice when creating slide content
Undo and Redo
Saving a presentation
Saving a presentation using a different name
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
MANIPULATING SLIDES
Inserting slides with a particular slide layout
Modifying the slide layout
Changing the background colour on the active slide
Changing background colour on all the slides within a presentation
THEMES
Applying a theme to a presentation
TEXT BOXES (PLACEHOLDERS)
What are Text Boxes (Placeholders)?
Resizing a Text Box (Placeholder)
Moving a Text Box (Placeholder)
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
SELECTING, COPYING MOVING, RESIZING AND DELETING TEXT
Selecting text
Moving text within a slide
Moving text between slides within a presentation or between presentations
Copying text within a slide
Copying text between slides within a presentation or between presentations
Deleting text
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
SEARCHING YOUR PRESENTATION
Using Find
Using Replace
FONT FORMATTING
Font formatting options
Changing the font type
Changing font size
Increasing or decreasing the font size
Bold, Italic or Underline formatting
Strikethrough effects
Shadow effects
Character spacing
Changing case
Font colour
Clearing all text formatting
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
PARAGRAPH FORMATTING
Text alignment
Columns
Modifying bullet point formatting
Using numbering instead of bullet points
Changing the list level
Indenting bulleted text
Line spacing vs. paragraph spacing
Line spacing
Paragraph spacing
Using Outline view
PowerPoint Presenter Notes
Text direction
Text alignment within a Text Box (placeholder)
Text AutoFit
Using the Format Painter
TABLES
Table selection techniques
Column selection
Row selection
Entire table selection
Creating a table
Applying a style to a table
Cell background shading
Adding table effects
Adding 'Quick Styles' to selected text
Applying borders to cells
Deleting rows or columns
Inserting rows or columns
Modifying column width and row height
Distributing rows and columns
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
SELECTING, COPYING MOVING, RESIZING AND DELETING ILLUSTRATIONS
Selecting an illustration
Moving an illustration
Copying an illustration
Deleting an illustration
Resizing an illustration
Stretching an illustration
Copying illustrations between presentations
Moving illustrations between presentations
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
INSERTING ILLUSTRATIONS
Inserting Illustrations within PowerPoint
Inserting pictures
Inserting Clip Art
Inserting Shapes
Inserting text into a shape
Inserting perfect circles or perfect squares
Inserting a line
Inserting a drawn line
Inserting an arrow
Inserting a text box
Inserting SmartArt
Inserting Charts
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
FORMATTING SHAPES
Formatting the shape background fill colour style
Formatting the shape line weight and style
Formatting the shape line colour
Applying a shadow to an illustration
Modifying arrow line shapes and size
Rotating or flipping an illustration
Rotating illustrations by dragging with the mouse
Layering illustrations to the front or back
Aligning graphics relative to each other or relative to the slide
Aligning shapes relative to the left of a slide
Aligning shapes relative to the center of a slide
Aligning shapes relative to the right of a slide
Aligning shapes relative to the top of a slide
Aligning shapes relative to the bottom of a slide
Grouping and ungrouping objects
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
FORMATTING CHARTS
Changing the chart type
Changing the background colour in the chart
Changing the column, bar, line or pie slice colours in the chart
Chart title manipulation
Adding data labels to a chart
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
ORGANISATION CHARTS
What is an organisation chart?
Creating an organisation chart
Adding labels to items within an organisation chart
Adding a co-worker to an organisation chart
Adding a subordinates within an organisation chart
Adding a manager within an organisation chart
Removing an item from an organisation chart
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
MOVING, COPYING AND DELETING SLIDES
Moving slides within a presentation or between presentations
Copying slides within a presentation
Deleting a slide or slides
Copying slides between presentations
Moving slides between presentations
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
SLIDE MASTERS
What is a slide master?
Inserting a picture (clipart) into a master slide
Inserting an image (from a file) into a master slide
Inserting a drawn object (shape) into a master slide
Removing a graphic from a master slide
Creating a footer
Automatic slide numbering
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
SLIDE SHOWS
Running a slide show
Slide show transition effects
Slide show animation effects
Modifying slide show animation effects
Hiding slides
isplaying hidden slides
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
PRINTING AND PROOFING
Spell-checking
Using Portrait or Landscape slide orientation
Selecting your output format
Visually inspect each slide before printing
Printing a presentation
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
CUSTOMISING AND COMPATIBILITY ISSUES
Modifying PowerPoint options
Compatibility issues when saving a presentation
Other file types you can use for saving a presentation
Saving a presentation as a template
Creating a new presentation based on a customised template
ICDL ECDL Module 6 Syllabus 5.0
THE MICROSOFT PowerPoint 2007 SCREEN
THE MICROSOFT PowerPoint 2007 SCREEN
check back soon there are more topics
ICDL ECDL Module 5 Syllabus 5.0
ICDL ECDL Module 5 Syllabus 5.0
ICDL ECDL Courseware Outline
ICDL ECDL Courseware Training Materials for IT Trainers
THE MICROSOFT Access 2007 SCREEN
DATABASE CONCEPTS
What is a database?
What are databases used for?
What is a relational database?
What is a table?
What is a record (row)?
What is a field (column)?
What is data?
The difference between data and information
Data types
Common uses of large-scale databases
Database designers, database administrators and database users
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
A FIRST LOOK AT ACCESS 2007
Opening Access 2007
Exploring the Access 2007 window
The Ribbon (Toolbar)
Ribbon tabs
Groups & Dialog Box Launcher
Navigating - Quick keys (shortcut keys)
Navigating – Pointer keys & quick keys
Navigating – Mouse wheel
Contextual tabs
Minimising the Ribbon
Quick Access Toolbar
The Office Button
Microsoft Access Help
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
OPENING A DATABASE & SECURITY ISSUES
Opening a database
Security warnings
Trusted Locations - Trust Centre
Setting the default folder location within Access
CREATING A DATABASE & USING VIEWS
Creating a new database
Creating a new blank database
Saving a table
Adding and renaming fields
Using Datasheet View
Using Design View
Changing the view
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
TABLE MODIFICATION AND NAVIGATION
Adding Fields - Design ViewData Type - Overview
Data Type - Descriptions
Using the Attachment data type
Adjusting column width
Moving a column to rearrange the column order
Adding records to a table
Navigating through records within a table
Navigation Pane
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
FIELD PROPERTIES, VALIDATION & INPUT MASKS
Field Properties
Input Mask
Validation Rules
Field Properties - Guides Tables
MANIPULATING RECORDS & TABLES
Closing an Object - Table
Renaming an Object - Table
Editing data within a record
Deleting data within a record
Using the Undo command
Deleting a single record
Deleting multiple records
Save As – Database Object
Deleting a table
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
PRIMARY KEYS AND INDEXING
Defining a Primary Key
Indexing
Creating a single-field Index
Creating a multiple-field Index
Deleting multi-field indexes
FILTERING & SORTING
Text Filters
Applying a single filter
Clearing a single filter
Creating multiple filters
Clearing multiple filters
Sorting
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
RELATIONSHIPS
Table relationships
One-to-many relationship
Many-to-many relationship
One-to-one relationships
Creating relationships between tables
Referential integrity
Cascade options
Cascade update related fields
Cascade delete related records
Enabling cascade options
Deleting relationships
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
ACCESS 2007 FORMS
Forms overview
Creating forms
Modifying forms
Modifying a form title
Modifying a form logo
Modifying a form label
Saving a form
Form View
Adding and formatting attachments
Modifying records
Deleting records
Adding records
Closing forms
Opening forms
Deleting a form
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
ACCESS 2007 QUERIES
What are queries?
Creating a simple query
Adding criteria to a query
Running a query
Editing criteria in a query
Saving a query
Creating a two table query and sorting the results
What are Wildcards?
Deleting a query
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
ACCESS 2007 REPORTS
What are reports?
Creating a simple report
Using the Report Wizard
Modifying the layout of a report
Widening a report column
Modifying the report title
Adding logos to a report
AutoFormating a report
Modifying field names within a report
Inserting and formatting the date & time
Adding available fields to a report
Resizing reports for printing
Closing a report
Deleting a report
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
ACCESS 2007 PRINTING & EXPORTING ISSUES
What does exporting data mean?
What is a spreadsheet format?
What is text only and CSV format?
What is an XML file?
Exporting a table or query output as an Excel spreadsheet using the Export Wizard
Exporting a table or query output as a text file using the Export Wizard
Exporting a table or query output as an XML formatted file using the Export Wizard
Considerations before printing
Print previewing
Which orientation, portrait or landscape?
Adjusting layout in Print Preview
Setting margins
Printing a complete table
Printing selected records
Printing a query or reports
Printing forms
ICDL ECDL Module 5 Syllabus 5.0
THE MICROSOFT Access 2007 SCREEN
check back soon there are more topics
ICDL ECDL Module 4 Syllabus 5.0
ICDL ECDL Module 4 Syllabus 5.0
ICDL ECDL Courseware Outline
ICDL ECDL Courseware Training Materials for IT Trainers
THE MICROSOFT Excel 2007 SCREEN
A FIRST LOOK AT EXCEL
Starting the Excel program
What is the Active Cell?
The Excel cell referencing system
Entering numbers and text
Default text and number alignment
Adding a column of numbers
Worksheets and Workbooks
Saving a workbook
Closing a workbook
Creating a new workbook
Opening a workbook
Switching between workbooks
Saving a workbook using another name
Saving a workbook using a different file type
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
HELP
Getting help
Searching for Help
The Help 'Table of Contents'
Printing a Help topic
Alt key help
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
SELECTION TECHNIQUES
Why are selection techniques important?
Selecting a cell
Selecting a range of connecting cells
Selecting a range of non-connecting cells
Selecting the entire worksheet
Selecting a row
Selecting a range of connecting rows
Selecting a range of non-connected rows
Selecting a column
Selecting a range of connecting columns
Selecting a range of non-connecting columns
Good practice when creating of editing lists
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
MANIPULATING ROWS AND COLUMNS
Inserting rows into a worksheet
Inserting columns into a worksheet
Deleting rows within a worksheet
Deleting columns within a worksheet
Modifying column widths
Modifying column widths using 'drag and drop'
Automatically resizing the column width to fit contents
Modifying row heights
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
COPYING, MOVING AND DELETING
Copying a cell or range contents within a workbook.
Deleting cell contents
Moving the contents of a cell or range within a workbook
Editing cell content
Undo and Redo
Copying the contents of a cell or range between worksheets (within the same workbook)
Moving the contents of a cell or range between worksheets (within the same workbook)
Moving the contents of a cell or range between worksheets (in different workbooks)
Copying the contents of a cell or range between worksheets (in different workbooks)
AutoFill
Sorting a cell range
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
SEARCHING
Searching and replacing data
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
MANIPULATING WORKSHEETS
Switching between worksheets
Renaming a worksheet
Good practice with naming worksheets
Inserting a new worksheet
Deleting a worksheet
Copying a worksheet within a workbook
Moving a worksheet within a workbook
Copying or moving worksheets between workbooks
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
FONT FORMATTING
Font type
Font size
Bold, italic, underline formatting
Cell border formatting
Formatting the background colour
Formatting the font colour
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
ALIGNMENT FORMATTING
Aligning contents in a cell range
Centring a title over a cell range
Cell orientation
Text wrapping
Format painter
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
NUMBER FORMATTING
Number formats
Decimal point display
Applying and removing comma style formatting (to indicate thousands)
Currency symbol
Date styles
Percentages
Applying Percentage formatting to a cell or range
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
FREEZING ROW AND COLUMN TITLES
Techniques for freezing row and column titles
FORMULAS
Creating formulas
Good Practice: The easy way to create formulas
Copying formulas
Operators
Formula error messages
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
RELATIVE & ABSOLUTE CELL REFERENCING
Relative cell referencing within formulas
Absolute cell referencing within formulas
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
FUNCTIONS
What is a function?
Common functions
Sum function
Average function
Max function
Min function
Count function
The COUNTA function
The COUNTBLANK function
What are 'IF functions'?
Using the IF function
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
USING CHARTS
Inserting a column chart
Inserting a line chart
Inserting a bar chart
Inserting a pie chart
Resizing a chart
Deleting a chart
Chart title or labels
Chart background colour
Changing the column, bar, line or pie slice colours in a chart
Modifying the legend fill colour
Changing the chart type
Modifying charts using the Layout tab
Copying and moving charts within a worksheet
Copying and moving charts between worksheets
Copying and moving charts between workbooks
CUSTOMISING EXCEL
Modifying basic Excel options
Minimising the Ribbon
AutoCorrect options
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
WORKSHEET SETUP
Worksheet margins
Worksheet orientation
Worksheet page size
Headers and footers
Header and footer fields
Scaling your worksheet to fit a page(s)
ICDL ECDL Module 4 Syllabus 5.0
THE MICROSOFT Excel 2007 SCREEN
PREPARING TO PRINT A WORKSHEET
Visually check your calculations
Displaying gridlines when printing
Printing titles on every page when printing
Printing the Excel row and column headings
Spell checking
Previewing a worksheet
Comparing workbooks side by side
Zooming the view
Printing options
Subscribe to:
Posts (Atom)