Microsoft Word EXPERT 2007Exam Structure: 23 Questions in 50 Minutes, Pass rate 70%
Exam Objectives as stated by Microsoft
Creating and Modifying Advanced Document Types
Create a mail merge document. This objective may include but is not limited to: creating a new recipient list, selecting recipients from Outlook contacts, and conditional mail merge
Create and manage master documents. This objective may include but is not limited to: converting a document to a master document, converting an outline to a master document, importing subdocuments, and managing subdocuments
Create forms. This objective may include but is not limited to: creating forms using fields, creating forms using content controls, and protecting forms
Customizing Word 2007
Customize the Quick Access toolbar. This objective may include but is not limited to: adding commands not in the ribbon, adding separators, and reorganizing commands
Change default save options. This objective may include but is not limited to: file formats and file locations
Assign keyboard shortcuts. This objective may include but is not limited to: assigning keyboard shortcuts to an existing macro, a style, a symbol, or autotext
Manage building blocks. This objective may include but is not limited to: distributing building blocks for reuse and creating a custom building block
Managing Styles and Templates
Manage styles. This objective may include but is not limited to: updating style based on selected text, copying styles from one document or template to another, and setting outline levels for styles
Manage style sets. This objective may include but is not limited to: creating a custom style set, saving a custom style set, and modifying an existing style set
Manage multilevel lists. This objective may include but is not limited to: creating a multilevel list, linking styles to a multilevel list, modifying an existing multilevel list, and defining a new number format
Manage templates. This objective may include but is not limited to: attaching a global template, attaching a local template, automatically updating styles using an attached template, saving style changes to the attached template, and saving gallery changes to the attached template
Managing Data Objects and Automation
Manage objects. This objective may include but is not limited to: creating an object, embedding an existing object, linking to an existing object, and display as icon
Manage XML. This objective may include but is not limited to: viewing XML tags, moving text with XML tags, validating a document against an XML schema, and attaching a custom XML schema
Record and edit a macro. This objective may include but is not limited to: recording a macro in a document, recording a macro in a template, inserting a breakpoint, stepping through a macro, and changing actions in a macro
Manage an existing macro. This objective may include but is not limited to: moving macros between documents (copy a macro, rename a copied macro, import a macro, export a macro) and configuring macro security (digitally sign a macro, macro security levels)
Managing Fields and References
Create a custom TOC. This objective may include but is not limited to: including or excluding specific levels, including or excluding specific styles, and modifying the TOC properties
Insert cross-references within a document. This objective may include but is not limited to: inserting reference to a document element, inserting a specific type of reference, and inserting above/below reference
Manage fields. This objective may include but is not limited to: updating all fields in a document, converting all fields of a document to text, creating a custom field by using modifiers and switches, changing the display format of a data field (switches), associating properties in the Document Information Panel, and creating a custom document property field
Create object captioning. This objective may include but is not limited to: autocaptioning different object types (numbering, position) and creating a custom label (numbering, position)
Managing Content
Manage visual content. This objective may include but is not limited to: creating a custom watermark and inserting and modifying a SmartArt graphic (modify a SmartArt graphic layout, convert a list to a SmartArt graphic)
Manage table properties. This objective may include but is not limited to: repeating a header row on subsequent pages, allowing a row to break across pages, and wrapping text around a table
Apply paste options. This objective may include but is not limited to: setting default paste options and applying paste options for text, tables, graphics, and lists
Find and replace content. This objective may include but is not limited to: finding and replacing content by format, using special characters, and using wildcards
Managing Documents
Embed fonts. This objective may include but is not limited to: embedding fonts on the current document, all new documents, all characters, or characters in use
Apply variable formatting by using sections. This objective may include but is not limited to: restarting page numbering with a different number format, linking and unlinking headers and footers, changing page orientation, changing page size and margins, and applying advanced page setup options (automatically align content vertically on a page, add line numbering)
Restrict formatting and editing. This objective may include but is not limited to: restricting editing to selected parts of a document, limiting formatting to specific styles, allowing only specific types of editing, and allowing per-user document permissions
Recover documents. This objective may include but is not limited to: Open and Repair, recovering text from any file, and locating the autorecover file (.asd file)
Combine multiple documents. This objective may include but is not limited to: Insert file option and Insert objects
__________________________________________________________________________ |
Microsoft Excel EXPERT 2007Exam Structure: 26 Questions in 50 Minutes, Pass rate 70%
Exam Objectives as stated by Microsoft
Capturing Data
Restrict data entry by using data validation. This objective may include but is not limited to: referencing external data in drop-down lists, validating data by using formulas, and encircling invalid data
Link form controls to cells. This objective may include but is not limited to: scroll bars, check box, label, and drop-down
Import data from an external source. This objective may include but is not limited to: importing data from a text file, importing data by using a Web query, using the Microsoft Query Wizard to edit an existing query, and referencing data in a database
Link to data in an external source. This objective may include but is not limited to: referencing data in another workbook, refreshing and editing workbook links, and changing data refresh options to optimize file size
Calculating Data by Using Advanced Formulas
Create formulas that combine Lookup & Reference and Statistical functions. This objective may include but is not limited to: using common Lookup & Reference functions (HLOOKUP, VLOOKUP, TRANSPOSE, INDIRECT, MATCH, INDEX, CHOOSE) and using common Statistical functions (COUNTIF, COUNTIFS, COUNTBLANK, AVERAGEIF, AVERAGEIFS, FREQUENCY)
Create formulas that combine Date & Time, Text, and Logical functions. This objective may include but is not limited to: using Date & Time functions, using Text functions, and using common Logical functions (IFERROR, Nested IF, OR, and AND)
Manage and reference defined names. This objective may include but is not limited to: creating a dynamic named range, creating and referencing a named formula, modifying named ranges by using Names Manager, and navigating across worksheets by using named ranges
Audit formulas. This objective may include but is not limited to: trace dependents, trace precedents, and adding a watch to the Watch Window
Managing Data Ranges
Consolidate data ranges. This objective may include but is not limited to: consolidating data ranges by position, by category, or with links to a source
Select and manipulate similar cells and objects. This objective may include but is not limited to: blanks, comments, objects, conditional formats, formulas, visible cells only, and find and replace by format
Apply advanced filtering. This objective may include but is not limited to: using multiple conditionals on the same column, using the OR condition across multiple columns, and applying filtering to unique records only
Protect data in a worksheet. This objective may include but is not limited to: locking and unlocking cells, locking and unlocking objects, and hiding formulas
Summarizing and Analyzing Data
Create PivotTables and PivotCharts. This objective may include but is not limited to: consolidating multiple data ranges by using PivotTables, creating a PivotTable from an existing worksheet, creating a PivotTable linked to an external database, and creating a PivotChart from an existing worksheet
Modify PivotTable content. This objective may include but is not limited to: grouping (group by dates, group by numbers, group by text), inserting a calculated field, and showing report filter pages
Perform what-if analysis. This objective may include but is not limited to: using Scenario Manager (create scenarios, compare scenarios), using a data table, using Goal Seek, and using the Solver add-in
Formatting Worksheet and Chart Content
Create custom number formats. This objective may include but is not limited to: number formats, date and time formats, and conditional number formats
Define advanced conditional formatting rules by using formulas. This objective may include but is not limited to: creating rules based on dates, creating rules based on numbers, and creating rules based on text
Add visual elements to a chart. This objective may include but is not limited to: adding a Z axis, adding a second Y axis, and adding analysis indicators (Trendlines, R-squared value, Series lines, High-Low lines)
Managing Macros and User-Defined Functions
Record and edit a macro. This objective may include but is not limited to: recording a macro and editing a macro in Visual Basic for Applications (VBA)
Manage existing macros. This objective may include but is not limited to: moving macros between workbooks, assigning a shortcut key to an existing macro, assigning a macro to a button in a worksheet, and configuring macro security levels
Create a user-defined function (UDF).
__________________________________________________________________________ |
Microsoft Outlook 2007Exam Structure: 32 Questions in 50 Minutes, Pass rate 70%
Exam Objectives as stated by Microsoft
MANAGING MESSAGING
Create and send e-mail message
Create and manage your signature and automated messages
Managed e-mail message attachments
Configure e-mail message sensitivity and
importance settings
Configure e-mail message security settings
Configure e-mail message delivery reports
View e-mail messages
MANAGING SCHEDULING
Create appointments, meetings and events
Send meeting requests
Update, cancel, and respond to meeting requests
Customise calendar settings
Share your calendar with others
View other calendars
MANAGING TASKS
Create and modify contacts
Accept, decline, assign, update, and respond to tasks
MANAGING CONTACTS AND PERSONAL CONTACTS INFORMATION
Create and modify contacts
Edit and use electronic business cards
Create and modify distribution lists
Create a secondary address book
ORGANISING INFORMATION
Categorise items by colour
Create and manage data files
Organise mail folders
Locate items by using the search feature
Create, modify, and remove rules to manage e-mail messages.
__________________________________________________________________________ |
