I OFFICE FEATURES.
Chapter 1: Office Basics.
Start and Exit Office Applications.
Navigate the Program Windows.
Work with the Ribbon.
Customise the Quick Access Toolbar.
Get Help with Office.
Chapter 2: Working with Files.
Create a New File.
Save a File.
Open a File.
Print a File.
Select Data.
Cut, Copy and Paste Data.
Chapter 3: Office Graphics Tools.
Insert a Picture or Clip Art.
Resize and Move Objects.
Rotate and Flip Objects.
Crop a Picture.
Change a Picture.
II WORD.
Chapter 4: Adding Text.
Change Word's Views.
Type and Edit Text.
Insert Symbols and Special Characters.
Chapter 5: Formatting Text.
Change the Font, Size and Colour.
Align Text.
Set Line Spacing.
Indent Text.
Set Tabs.
Set Margins.
Copy Formatting.
Clear Formatting.
Format with Styles.
Apply a Template.
Chapter 6: Adding Extra Touches.
Create Columns.
Insert a Table.
Use Headers, Footers and Footnotes.
Insert Page Numbers and Page Breaks.
Create an Index.
Create a Table of Contents.
Chapter 7: Reviewing Documents.
Find and Replace Text.
Check Spelling and Grammar.
Work with AutoCorrect.
Track and Review Document Changes.
III EXCEL.
Chapter 8: Building Spreadsheets.
Enter Cell Data.
Select Cells.
Faster Data Entry with AutoFill.
Change the Font and Size.
Change Number Formats.
Apply Conditional Formatting.
Add Columns and Rows.
Freeze a Column or Row.
Name a Range.
Delete Data or Cells.
Chapter 9: Worksheet Basics.
Add a Worksheet.
Name a Worksheet.
Change Page Setup Options.
Move and Copy Worksheets.
Delete a Worksheet.
Find and Replace Data.
Sort Data.
Filter Data.
Chapter 10: Working with Formulas and Functions.
Create a Formula.
Apply Absolute and Relative Cell References.
Understanding Functions.
Apply a Function.
Total Cells with AutoSum.
Audit a Worksheet for Errors.
Create a Chart.
IV POWERPOINT.
Chapter 11: Creating a Presentation.
Create a Photo Album Presentation.
Create a Presentation with a Template.
Build a Blank Presentation.
Change PowerPoint Views.
Insert Slides.
Change the Slide Layout.
Chapter 12: Populating Presentation Slides.
Add and Edit Slide Text.
Change the Font, Size and Colour.
Set Line Spacing.
Add a Text Box to a Slide.
Add Other Objects to a Slide.
Move a Slide Object.
Resize a Slide Object.
Chapter 13: Assembling and Presenting a Slide Show.
Reorganise Slides.
Record Narration.
Set Up a Slide Show.
Run a Slide Show.
V ACCESS.
Chapter 14: Database Basics.
Create a Database Based on a Template.
Create a Blank Database.
Create a New Table.
Change Table Views.
Add or Move a Field in a Table.
Delete or Hide a Field in a Table.
Create a Form.
Change Form Views.
Move or Delete a Field in a Form.
Chapter 15: Adding, Finding and Querying Data.
Add a Record to a Table.
Add a Record to a Form.
Navigate Records in a Form.
Search for a Record in a Form.
Sort Records.
Filter Records.
Use Conditional Formatting.
Perform a Simple Query.
Create a Report.
VI OUTLOOK.
Chapter 16: Organising with Outlook.
View Outlook Components.
Schedule an Appointment.
Schedule an Event.
Create a New Contact.
Create a New Task.
Chapter 17: E-mailing with Outlook.
Compose and Send a Message.
Send a File Attachment.
Read an Incoming Message.
Reply To or Forward a Message.
Add a Sender to Your Outlook Contacts.
Delete a Message.
View Conversations.
Screen Junk E-mail.
INDEX.
Chapter 1: Office Basics
Start and Exit Office Applications
Before you can begin working with a Microsoft Office application, also called a program, you must open the application.
There are a few ways to start an application. One is to launch it from the Start menu, as described in this task. Another is to double-click the program's shortcut icon on the desktop.
When you finish your work, you can close the program. If applicable, you can save your work before exiting a program completely.
Start an Office Application
1 Click Start.
2 Click All Programs.
Note: The All Programs menu option changes to a Back menu option.
3 Click Microsoft Office.
4 Click the name of the program that you want to open.
A The program that you selected opens in a new window.
Note: See the next section to learn how to identify different areas of the program window.
Exit an Office Application
1 Click the Close button ().
A You can also click the File tab and then click Exit.
If you have not yet saved your work, the program prompts you to do so before exiting.
2 Click Save.
The program window closes.
B If you click Don't Save, the program closes without saving your data.
C If you click Cancel, the program window remains open.
Create a Shortcut Icon for an Office Application
1 Right-click a blank area of the desktop and click New and then Shortcut.
The Create Shortcut dialog box appears.
2 Click Browse, navigate to the Office program, click the filename and click OK.
3 Click Next.
4 Type a name for the shortcut.
5 Click Finish.
The new shortcut icon appears on the desktop.
Navigate the Program Windows
All Office programs share a common appearance and many of the same features. These features include a Ribbon, which appears instead of the menus and toolbars found in previous versions of Microsoft Office; a Quick Launch toolbar, which features a customisable set of frequently used commands; and scroll bars, which you can use to navigate an open file in a program window. When you learn how to navigate one Office program, you can use the same skills to navigate the others. If you are new to Office, you should take a moment to familiarise yourself with the suite's various on-screen elements.
A Title Bar
Displays the name of the open file and the Office program.
B Quick Access Toolbar
Displays quick access buttons to the Save, Undo and Redo commands.
C File Tab Menu
Displays a menu of file commands, such as New and Open.
D Ribbon
Displays groups of related commands in tabs. Each tab offers buttons for performing common tasks.
E Status Bar
Displays information about the current worksheet or file.
F Program Window Controls
Displays buttons to minimise the program window, restore the window to full size and close the window.
A Formula Bar
This appears only in Excel. Use this bar to type and edit formulas and perform calculations on your worksheet data.
B Work Area
The area where you add and work with data in a program. Depending on the Office program, the work area may be a document, a worksheet or a slide.
C Document Window Controls
Use these buttons to minimise or restore the current document within the program window.
D Zoom Controls
Use this feature to zoom your view of a document.
E Scroll Bars
Use the vertical and horizontal scroll bars to scroll through the item shown in the work area.
Work with the Ribbon
Instead of the menus and toolbars found in earlier versions of Office, Office 2010 features the Ribbon, which offers an intuitive way to locate and execute commands.
The Ribbon is grouped into tabs, each containing groups of related commands. For example, the Home tab in Microsoft Word contains commands for changing the font, setting text alignment, indenting text and so on. Some tabs appear only when needed, such as when you are working with a table or picture in a document.
The Ribbon is maximised by default, but you can minimise it to view more of your program window.
Use the Ribbon
1 Click a tab.
The tab organises related tasks and commands into logical groups.
2 Click a button to activate a command or feature.
A Buttons with arrows display additional commands.
B With some groups of commands, you can click the corner group button () to display a dialog box of additional settings.
When you position the mouse pointer over Live Preview options on the Ribbon, you see the results in the document before applying the command.
Minimise the Ribbon
1 Double-click a tab name.
The Ribbon is minimised.
2 Double-click the tab name again to maximise the Ribbon.
Keep the Ribbon Minimised
1 Right-click a tab on the Ribbon.
2 Click Minimize the Ribbon.
The program's Ribbon is minimised at the top of the screen.
To use a Ribbon while it is minimised, simply click the tab containing the tools that you want to access.
Customise the Quick Access Toolbar
The Quick Access toolbar, which appears on-screen regardless of what tab is currently shown in the Ribbon, offers quick access to the Save, Undo and Redo commands.
You can customise this toolbar to include other commands, such as the Quick Print command or another command you use often. Alternatively, you might customise the toolbar to omit commands that appear by default.
By default, the Quick Access toolbar appears in the top left corner of the program window, above the Ribbon. You can choose to display the toolbar below the Ribbon instead.
1 Click the Customize Quick Access Toolbar button ().
2 Click More Commands.
A You can click any of the common commands to add them to the toolbar.
B You can click Show Below the Ribbon if you want to display the toolbar below the Ribbon.
The Options dialog box opens with the options to customise the Quick Access Toolbar shown.
3 Click the Choose commands from .
4 Click a command group.
5 Click the command that you want to add to the toolbar.
6 Click the Add button.
C Office adds the command.
You can repeat Steps 3...
