Microsoft Word EXPERT 2010Exam Objectives as stated by Microsoft
Sharing and Maintaining Documents
Configure Word options.
This objective may include but is not limited to: changing default program, spelling, and grammar checking options
Apply protection to a document.
This objective may include but is not limited to: restricting editing and applying controls or restrictions to document access
Apply a template to a document.
This objective may include but is not limited to: modifying an existing template, creating a new template, applying a template to an existing document, and managing templates by using the Organizer
Formatting Content
Apply advanced font and paragraph attributes.
This objective may include but is not limited to: using character attributes and character-specific styles
Create tables and charts.
This objective may include but is not limited to: inserting tables by using Microsoft Excel data in tables, applying formulas or calculations on a table, modifying chart data, saving a chart as a template, and using the chart Layout tab
Construct reusable content in a document.
This objective may include but is not limited to: creating customized building blocks, saving a selection as a quick part, saving quick parts after a document is saved, inserting text as a quick part, and adding content to a header or footer
Link sections.
This objective may include but is not limited to: linking text boxes, breaking links between text boxes, and linking different sections
Tracking and Referencing Documents
Review, compare, and combine documents.
This objective may include but is not limited to: applying tracking, merging different versions of a document, tracking changes in a combined document, and reviewing comments in a combined document
Create a reference page.
This objective may include but is not limited to: adding citations, managing sources, compiling a bibliography, and applying cross references
Create a Table of Authorities in a document.
This objective may include but is not limited to: applying default formats, adjusting alignment, applying a tab leader, modifying styles, marking citations, and using passim (short form)
Create an index in a document.
This objective may include but is not limited to: specifying index type, columns, and language, modifying an index, and marking index entries
Performing Mail Merge Operations
Execute Mail Merge.
This objective may include but is not limited to: merging rules and sending personalized email messages to multiple recipients
Create a Mail Merge by using other data sources.
This objective may include but is not limited to: using Microsoft Outlook, Access, Excel, or Word tables as data source for a mail merge operation
Create labels and forms.
This objective may include but is not limited to: preparing data and creating mailing labels, envelope forms, and label forms
Managing Macros and Forms
Apply and manipulate macros.
This objective may include but is not limited to: recording a macro, running a macro, and applying macro security
Apply and manipulate macro options.
This objective may include but is not limited to: running macros when a document is opened, running macros when a button is clicked, assigning a macro to a command button, and creating a custom macro button on the Quick Access Toolbar
Create forms.
This objective may include but is not limited to: using the Controls group, adding Help content to form fields, linking a form to a database, and locking a form
Manipulate forms.
This objective may include but is not limited to: unlocking a form, adding fields to a form, and removing fields from a form
__________________________________________________________________________ |
Microsoft Excel EXPERT 2010Exam Objectives as stated by Microsoft
Sharing and Maintaining Workbooks
Apply workbook settings, properties, and data options.
This objective may include but is not limited to: setting advanced properties, saving a workbook as a template, and importing and exporting XML data
Apply protection and sharing properties to workbooks and worksheets.
This objective may include but is not limited to: protecting the current sheet, protecting the workbook structure, restricting permissions, and requiring a password to open a workbook
Maintain shared workbooks.
This objective may include but is not limited to: merging workbooks and setting Track Changes options
Applying Formulas and Functions
Audit formulas.
This objective may include but is not limited to: tracing formula precedents, dependents, and errors, locating invalid data or formulas, and correcting errors in formulas
Manipulate formula options.
This objective may include but is not limited to: setting iterative calculation options and enabling or disabling automatic workbook calculation
Perform data summary tasks.
This objective may include but is not limited to: using an array formula and using a SUMIFS function
Apply functions in formulas.
This objective may include but is not limited to: finding and correcting errors in functions, applying arrays to functions, and using Statistical, Date and Time, Financial, Text, and Cube functions
Presenting Data Visually
Apply advanced chart features.
This objective may include but is not limited to: using Trend lines, Dual axes, chart templates, and Sparklines
Apply data analysis.
This objective may include but is not limited to: using automated analysis tools and performing What-If analysis
Apply and manipulate PivotTables.
This objective may include but is not limited to: manipulating PivotTable data and using the slicer to filter and segment your PivotTable data in multiple layers
Apply and manipulate PivotCharts.
This objective may include but is not limited to: creating, manipulating, and analyzing PivotChart data
Demonstrate how to use the slicer.
This objective may include but is not limited to: choosing data sets from external data connections
Working with Macros and Forms
Create and manipulate macros.
This objective may include but is not limited to: running a macro, running a macro when a workbook is opened, running a macro when a button is clicked, recording an action macro, assigning a macro to a command button, creating a custom macro button on the Quick Access Toolbar, and applying modifications to a macro
Insert and manipulate form controls.
This objective may include but is not limited to: inserting form controls and setting form properties
__________________________________________________________________________ |
Microsoft Outlook 2010Exam Objectives as stated by Microsoft
Managing the Outlook Environment
Apply and manipulate Outlook program options. This objective may include but is not limited to: setting General, Mail, Calendar, Tasks, Notes and Journal, Advanced, and Language options
Manipulate item tags. This objective may include but is not limited to: categorizing items, setting flags, setting sensitivity level, marking items as read or unread, and viewing message properties
Arrange the Content Pane. This objective may include but is not limited to: showing or hiding fields in a list view, changing the reading view, and using the Reminders Window and People Pane
Apply search and filter tools. This objective may include but is not limited to: using built-in Search folders
Print an Outlook item. This objective may include but is not limited to: printing attachments, calendars, multiple messages, multiple contact records, tasks, and multiple notes
Creating and Formatting Item Content
Create and send email messages. This objective may include but is not limited to: specifying a message theme, specifying plain text, rich text, or HTML message content format, showing or hiding the From and Bcc fields, setting a reminder for message recipients, specifying the sending account, specifying the sent item folder, configuring message delivery options, configuring voting and tracking options, and sending a message to a contact group
Create and manage Quick Steps. This objective may include but is not limited to: performing, creating, editing, deleting, and duplicating Quick Steps, resetting Quick Steps to default settings
Create item content. This objective may include but is not limited to: inserting graphical elements and inserting a hyperlink
Format item content. This objective may include but is not limited to: using formatting tools, applying styles, creating styles and themes, using Paste Special, and formatting graphical elements
Attach content to email messages. This objective may include but is not limited to: attaching an Outlook item and attaching external files
Managing Email Messages
Clean up the mailbox. This objective may include but is not limited to: viewing mailbox size, saving message attachments, saving a message in an external format, ignoring a conversation, and using clean-up tools
Create and manage rules.
This objective may include but is not limited to: creating, modifying, and deleting rules
Manage junk mail. This objective may include but is not limited to: allowing a specific message (Not junk), and filtering junk mail with Never Block Sender, Never Block Sender's Domain, Never Block this Group or Mailing List, and Block Sender
Manage automatic message content. This objective may include but is not limited to: managing signatures, specifying the font for new HTML messages, plain-text messages, specifying options for replies and forwards, and setting a default theme for all HTML messages, stationery, and fonts
Managing Contacts
Create and manipulate contacts. This objective may include but is not limited to: modifying a default business card, forwarding a contact, and updating a contact in the address book
Create and manipulate contact groups. This objective may include but is not limited to: creating a contact group, managing contact group membership, showing notes about a contact group, forwarding a contact group, deleting a contact group, and sending a meeting to a contact group
Managing Calendar Objects
Create and manipulate appointments and events. This objective may include but is not limited to: setting appointment options, printing appointment details, forwarding an appointment, and scheduling a meeting with a message sender
Create and manipulate meeting requests. This objective may include but is not limited to: setting response options, updating a meeting request, canceling a meeting or invitation, and proposing a new time for a meeting
Manipulate the Calendar pane. This objective may include but is not limited to: arranging the calendar view, changing the calendar color, displaying or hiding calendars, and creating a calendar group
Working with Tasks, Notes, and Journal Entries
Create and manipulate tasks. This objective may include but is not limited to: creating a task, managing task details, sending a status report, marking a task as complete, moving or copying a task to another folder, assigning a task to another Outlook user, accepting or declining a task assignment, updating an assigned task, and using Current view
Create and manipulate notes. This objective may include but is not limited to: creating a note, changing the current view, and categorizing notes
Create and manipulate Journal entries. This objective may include but is not limited to: automatically record Outlook items, automatically record files, and editing a Journal entry
__________________________________________________________________________ |
Microsoft PowerPoint 2010Exam Objectives as stated by Microsoft
Managing the PowerPoint Environment
Adjust views. This objective may include but is not limited to: adjusting views by using ribbon or status bar commands
Manipulate the PowerPoint window. This objective may include but is not limited to: working with multiple presentation windows simultaneously
Configure the Quick Access Toolbar. This objective may include but is not limited to: showing the Quick Access Toolbar (QAT) below the ribbon
Configure PowerPoint file options. This objective may include but is not limited to: using PowerPoint, Proofing, and Save options
Creating a Slide Presentation
Construct and edit photo albums. This objective may include but is not limited to: adding captions to pictures, inserting text, inserting images in black and white, reordering pictures in an album, and adjusting image rotation, brightness, and contrast
Apply slide size and orientation settings. This objective may include but is not limited to: setting up a custom size and changing the orientation
Add and remove slides. This objective may include but is not limited to: inserting an outline, reusing slides from a saved presentation, reusing slides from a slide library, duplicating selected slides, deleting multiple slides simultaneously, and including non-contiguous slides in a presentation
Format slides. This objective may include but is not limited to: formatting sections, modifying themes, switching to a different slide layout, applying a fill color, gradient, picture, texture, or pattern to a slide, and setting up slide footers
Enter and format text. This objective may include but is not limited to: using text effects, changing the indentation, alignment, line spacing, and direction of text, changing the formatting of bulleted and numbered lists, entering text in a placeholder text box, converting text to SmartArt, copying and pasting text, using Paste Special, and using Format Painter
Format text boxes. This objective may include but is not limited to: applying a fill color, gradient, picture, texture, or pattern to a text box, changing the outline color, weight, or style, changing the shape of the text box, applying effects, setting the alignment, creating columns in a text box, setting internal margins, setting the current text box formatting as the default for new text boxes, adjusting text wrapping, sizing and positioning a text box, and using AutoFit
Working with Graphical and Multimedia Elements
Manipulate graphical elements. This objective may include but is not limited to: arranging, positioning, and resizing graphical elements, applying effects, applying styles, applying borders, and adding hyperlinks
Manipulate images. This objective may include but is not limited to: applying color adjustments, applying image corrections (sharpen, soften, brightness, contrast), adding artistic effects to an image, removing a background, cropping a picture, compressing selected pictures or all pictures, changing a picture, and resetting a picture
Modify WordArt and shapes. This objective may include but is not limited to: setting the formatting of the current shape as the default for future shapes, changing the fill color or texture, changing the WordArt, converting to SmartArt
Manipulate SmartArt. This objective may include but is not limited to: adding and removing shapes, changing SmartArt styles, changing the SmartArt layout, reordering shapes, converting a SmartArt graphic to text, converting SmartArt to shapes, making shapes larger or smaller, and promoting or demoting bullet levels
Edit video and audio content. This objective may include but is not limited to: applying a style to video or audio content, adjusting, arranging, and sizing video or audio content, and adjusting playback options
Creating Charts and Tables
Construct and modify tables. This objective may include but is not limited to: drawing a table, inserting a Microsoft Excel spreadsheet, setting table style options, adding shading, borders, and effects, changing the alignment, resizing, merging or splitting columns and rows, distributing columns and rows, arranging columns and rows
Insert and modify charts. This objective may include but is not limited to: selecting a chart type, entering chart data, changing the chart type, changing the chart layout, switching row and column, selecting data, editing data
Apply chart elements. This objective may include but is not limited to: using chart labels, axes, gridlines, and backgrounds
Manipulate chart layouts. This objective may include but is not limited to: selecting chart elements and formatting selections
Manipulate chart elements. This objective may include but is not limited to: arranging chart elements, specifying a precise position, applying effects, resizing chart elements, applying Quick Styles, applying a border, and adding hyperlinks
Applying Transitions and Animations
Apply built-in and custom animations. This objective may include but is not limited to: using More Entrance, More Emphasis, and More Exit effects, and using More Motion paths
Apply effect and path options. This objective may include but is not limited to: setting timing and start options
Manipulate animations. This objective may include but is not limited to: changing the direction of an animation, attaching a sound to an animation, using Animation Painter, reordering animations, and selecting text options
Apply and modify transitions between slides. This objective may include but is not limited to: modifying a transition effect, adding a sound to a transition, modifying transition duration, and setting up manual or automatically timed advance options
Collaborating on Presentations
Manage comments in presentations. This objective may include but is not limited to: inserting and editing comments, showing or hiding markup, moving to the previous or next comment, and deleting comments
Apply proofing tools. This objective may include but is not limited to: using Spelling and Thesaurus features, comparing and combining presentations
Preparing Presentations for Delivery
Save presentations. This objective may include but is not limited to: saving the presentation as a picture presentation, PDF, XPS, outline, or OpenDocument presentation, saving a slide or object as a picture file, and saving a presentation as a show (.ppsx)
Share presentations. This objective may include but is not limited to: packaging a presentation for CD delivery, creating video, creating handouts (send to Microsoft Word), and compressing media
Print presentations. This objective may include but is not limited to: adjusting print settings
Protect presentations. This objective may include but is not limited to: setting a password, changing a password, and marking a presentation as final
Delivering Presentations
Apply presentation tools. This objective may include but is not limited to: adding pen and highlighter annotations, changing the ink color, erasing an annotation, and discarding or retaining annotations upon closing
Set up slide shows. This objective may include but is not limited to: setting up Slide Show, playing narrations, setting up Presenter view, using timings, showing media controls, broadcasting presentations, and creating a Custom Slide Show
Set presentation timing. This objective may include but is not limited to: rehearsing and keeping timings, adjusting a slide's timing
Record presentations. This objective may include but is not limited to: starting recording from the beginning of a slide show and starting recording from the current slide of the slide show
__________________________________________________________________________ |
Microsoft Access 2010Exam Objectives as stated by Microsoft
Managing the Access Environment
Create and manage a database. This objective may include but is not limited to: using Save Object As, Open, Save and Publish, Compact & Repair Database, and Encrypt with Password commands, creating a database from a template, and setting Access options
Configure the Navigation Pane. This objective may include but is not limited to: renaming objects, deleting objects, and setting Navigation options
Apply Application Parts. This objective may include but is not limited to: using Blank Forms, Quick Start, and user templates
Building Tables
Create tables. This objective may include but is not limited to: creating tables in Design View
Create and modify fields. This objective may include but is not limited to: inserting a field, deleting a field, renaming a field, Hide or Unhide fields, Freeze or Unfreeze fields, modifying data types, modifying the field description, and modifying field properties
Sort and filter records. This objective may include but is not limited to: using Find, Sort, and Filter commands
Set relationships. This objective may include but is not limited to: defining Primary Keys, using Primary Keys to create Relationships, and editing Relationships
Import data from a single data file. This objective may include but is not limited to: importing source data into a new table, appending records to an existing table, and importing data as a linked table
Building Forms
Create forms. This objective may include but is not limited to: using the Form Wizard, creating a Blank Form, using Form Design Tools, and creating Navigation forms
Apply Form Design Tab options. This objective may include but is not limited to: using the Themes, Controls, Header/Footer, and Tools groups
Apply Form Arrange Tab options. This objective may include but is not limited to: using the Table, Move, and Position groups
Apply Form Format Tab options. This objective may include but is not limited to: using the Background and Control Formatting groups
Creating and Managing Queries
Construct queries. This objective may include but is not limited to: using Select, Make Table, Append, and Crosstab query types
Manage source tables and relationships. This objective may include but is not limited to: using the Show Table and Remove Table commands, and creating ad hoc relationships
Manipulate fields. This objective may include but is not limited to: adding, removing, and rearranging fields, and using Sort and Show options
Calculate totals. This objective may include but is not limited to: using the Total row and using Group By
Generate calculated fields. This objective may include but is not limited to: performing calculations, using the Zoom box, and using Expression Builder
Designing Reports
Create reports. This objective may include but is not limited to: creating a Blank Report, using Report Design Tools, and using the Report Wizard
Apply Report Design Tab options. This objective may include but is not limited to: using the Themes, Grouping & Totals, Controls, Header/Footer, and Tools groups
Apply Report Arrange Tab options. This objective may include but is not limited to: using the Table, Move, Position, and Sizing & Ordering groups
Apply Report Format Tab options. This objective may include but is not limited to: adding color, background images, and conditional formatting
Apply Report Page Setup Tab options. This objective may include, but is not limited to: using the Page Size andPage Layout groups
Sort and filter records for reporting. This objective may include but is not limited to: using the Find, Sort, and Filter commands, and using view types
__________________________________________________________________________ |
