Formulas and functions

• Generate formulas using cell references
• Recognise and understand errors associated with formulas
• Understand and use relative, mixed and absolute cell referencing
• Generate formulas using basic functions
• Generate formulas using the 'IF' function

Formatting part Two

• Display cells with specified number of decimal places
• Format cells to display date style
• Format cells to display currency symbol
• Format cells to display numbers as percentages
• Change cell contents appearance
• Apply formatting to cell contents
• Apply colours to cell contents
• Copy formatting from on cell to another
• Apply text wrapping within a cell

Formatting part Three

• Align the contents of a cell
• Centre a title over a range of cells
• Adjust cell content orientation
• Add border effects to a cell or range

Charts and graphics

• Produce different types of charts and graphs
• Label an existing chart
• Change the background colour of a chart or graph
• Modify the appearance of a chart or graph
• Change the chart type
• Move charts or gaphs within a worksheet or between open spreadsheets
• Resize or delete charts or graphs

Prepare outputs

• Change worksheet margins
• Change worksheet orientation
• Adjust worksheet to fit on page
• Add or modify text in headers and footers
• Insert fields such as page numbering
• Understand the importance of checking spreadsheets prior to distribution
• Preview a worksheet
• Switch gridlines on and off
• Apply automatic titling
• Controlling printing

Using the application

• Opening and closing Microsoft Word
• Introduction to Microsoft Word
• Opening existing document
• Opening a new document (Default template)
• Saving
• Save as other formats
• Switch between open documents
• Using help
• Closing a document
• Viewing documents
• Modify toolbars
• Display and hide 'non-printing' characters
• Modify basic options

Main operations

• Inserting text
• Inserting special characters and symbols
• Selecting text
• Editing text
• Using undo and redo
• Duplicating text
• Moving text
• Deleting text
• Using find (Search)
• Using replace

Formatting part One

• Change font size and type
• Apply Bold, Italic and underline formatting
• Apply subscript and superscript
• Apply 'Case Changes'
• Apply colour to text
• Copy text formatting
• Apply styles to text
• Use hyphenation
• Insert and remove paragraph marks
• Insert and remove 'Soft carriage return' marks