Testovací centrum Certiport

Naše škola jako jedna z málo škol v celé České republice a organizací v Ústeckém kraji nabízí zájemcům možnost získání oficiální certifikace společnosti Microsoft na produkty MicrosoftOffice. V současné době jsou nabízeny certifikační testy pro sady Microsoft Office 2003,2007 a 2010. Certifikace probíhají na praktických testech, kde uchazeč musí prokázat své znalosti v rámci vybrané sady. Testy a zkoušky celé probíhají v anglickém jazyce, čímž je ale zaručena mezinárodní platnost vystaveného certifikátu, který je všeobecně uznáván zaměstnavateli po celém světě. Jedinou zkoušku, kterou je možné skládat v českém jazyce je Microsoft Office Word 2003. Díky našemu testovacímu středisku máte jedinečnou možnost se připojit k více než 8 milionům držitelů těchto certifikací a potvrdit a prokázat své znalosti v oblasti Microsoft Office. Pro absolvování testu kontaktuje vedoucího testovacího centra p. Karla Klatovského na emailové adrese karel.klatovsky(zavinac)stredni.eu a to minimálně 2 dny před plánovaným termínem složení certifikační zkoušky v podobě praktického testu. Ke zkoušce je nutné se prokázat občanským průkazem a během zkoušky nesmí mít uchazeč žádné pomůcky a musí souhlasit se smlouvou o mlčenlivosti (NDA - Non-disclosure agreement) co se obsahu jednotlivých testů týče. Úspěšný absolvent jakéhokoliv (i jednoho) certifikačního testu na oblast Microsoft Office získá titul a certifikaci Microsoft Office Specialist včetně práva na použití příslušného loga.

Cena za absolvování jedné zkoušky činí 899 Kč.

Zájemci s hlubšimi znalostmi aplikací sady Microsoft Office se mohou pokusit o získání certifikace Microsoft Office Specialist Master, která díky náročnějším zkouškám v aplikacích Word a Excel umožnuje získat tuto vyjímečnou certifikace a prokázat tak své odborné znalosti v těchto aplikacích. Požadavky na získání jednotlivých certifikací jsou uvedeny níže.

 

Microsoft Office 2007 Master

Microsoft Office 2003 Master
  • Using Microsoft® Office Word 2007
  • Using Microsoft® Office Excel® 2007
  • Using Microsoft® Office PowerPoint® 2007
  • Using Microsoft® Office Outlook® 2007
    —nebo—
    Using Microsoft® Office Access® 2007
  • Word 2003 Expert
  • Excel® 2003 Expert
  • PowerPoint® 2003
  • Outlook® 2003
    —nebo—
    Access® 2003

 

Požadavky na jednotlivé certifikace v rámci sady Microsoft Office 2010

 

 

 

 

 


Nabízené zkoušky

 

Certification

Exam number

MOS: Microsoft Office Word 2010

Exam 77-881

MOS: Microsoft Office Word 2010 Expert

Exam 77-887

MOS: Microsoft Office Excel 2010

Exam 77-882

MOS: Microsoft Office Excel 2010 Expert

Exam 77-888

MOS: Microsoft Office PowerPoint 2010

Exam 77-883

MOS: Microsoft Office Outlook 2010

Exam 77-884

MOS: Microsoft Office Access 2010

Exam 77-885

MOS: Microsoft SharePoint 2010

Exam 77-886

MOS: Microsoft Project 2010, Managing Projects

Exam 77-178

 

Certification

Exam number

MOS: Windows Vista for the Business Worker

Exam 77-600

MOS: Microsoft Office Word 2007

Exam 77-601

MOS: Microsoft Office Word 2007 Expert

Exam 77-850

MOS: Microsoft Office Excel 2007

Exam 77-602

MOS: Microsoft Office Excel 2007 Expert

Exam 77-851

MOS: Microsoft Office PowerPoint 2007

Exam 77-603

MOS: Microsoft Office Outlook 2007

Exam 77-604

MOS: Microsoft Office Access 2007

Exam 77-605

 

Certification

Exam

MOS: Word 2003

Word 2003

MOS: Word 2003 Expert

Word 2003 Expert

MOS: Excel 2003

Excel 2003

MOS: Excel 2003 Expert

Excel 2003 Expert

MOS: PowerPoint 2003

PowerPoint 2003

MOS: Access 2003

Access 2003

MOS: Outlook 2003

Outlook 2003

 

Témata a oblasti jednotlivých zkoušek

Word 2003 

Creating Content
 Insert and edit text, symbols and special characters 
 Insert frequently used and pre-defined text 
 Navigate to specific content 
 Insert, position and size graphics 
 Create and modify diagrams and charts 
 Locate, select and insert supporting information

Organizing Content
 Insert and modify tables 
 Create bulleted lists, numbered lists and outlines 
 Insert and modify hyperlinks

Formatting Content
 Format text 
 Format paragraphs 
 Apply and format columns 
 Insert and modify content in headers and footers 
 Modify document layout and page setup

Collaborating
 Circulate documents for review 
 Compare and merge documents 
 Insert, view and edit comments 
 Track, accept and reject proposed changes

Formatting and Managing Documents
 Create new documents using templates 
 Review and modify document properties 
 Organize documents using file folders 
 Save documents in appropriate formats for different uses 
 Print documents, envelopes and labels 
 Preview documents and Web pages 
 Change and organize document views and windows

Word 2003 Expert 

Formatting Content
 Create custom styles for text, tables and lists 
 Control pagination 
 Format, position and resize graphics using advanced layout features 
 Insert and modify objects 
 Create and modify diagrams and charts using data from other sources

Organizing Content
 Sort content in lists and tables 
 Perform calculations in tables 
 Modify table formats 
 Summarize document content using automated tools 
 Use automated tools for document navigation 
 Merge letters with other data sources 
 Merge labels with other data sources 
 Structure documents using XML

Formatting Documents
 Create and modify forms 
 Create and modify document background 
 Create and modify document indexes and tables 
 Insert and modify endnotes, footnotes, captions, and cross-references 
 Create and manage master documents and subdocuments

Collaborating
 Modify track changes options 
 Publish and edit Web documents 
 Manage document versions 
 Protect and restrict forms and documents 
 Attach digital signatures to documents 
 Customize document properties

Customizing Word
 Create, edit, and run macros 
 Customize menus and toolbars 
 Modify Word default settings

Excel 2003 

Creating Data and Content
 Enter and edit cell content 
 Navigate to specific cell content 
 Locate, select and insert supporting information 
 Insert, position, and size graphics

Analyzing Data
 Filter lists using AutoFilter 
 Sort lists 
 Insert and modify formulas 
 Use statistical, date and time, financial, and logical functions 
 Create, modify, and position diagrams and charts based on worksheet data

Formatting Data and Content
 Apply and modify cell formats 
 Apply and modify cell styles 
 Modify row and column formats 
 Format worksheets

Collaborating
 Insert, view and edit comments

Managing Workbooks
 Create new workbooks from templates 
 Insert, delete and move cells 
 Create and modify hyperlinks 
 Organize worksheets 
 Preview data in other views 
 Customize Window layout 
 Setup pages for printing 
 Print data 
 Organize workbooks using file folders 
 Save data in appropriate formats for different uses

 

Excel 2003 Expert 

Organizing and Analyzing Data
 Use subtotals 
 Define and apply advanced filters 
 Group and outline data
 Use data validation 
 Create and modify list ranges 
 Add, show, close, edit, merge and summarize scenarios 
 Perform data analysis using automated tools 
 Create PivotTable and PivotChart reports 
 Use Lookup and Reference functions 
 Use Database functions 
 Trace formula precedents, dependents and errors 
 Locate invalid data and formulas 
 Watch and evaluate formulas 
 Define, modify and use named ranges 
 Structure workbooks using XML

Formatting Data and Content
 Create and modify custom data formats 
 Use conditional formatting 
 Format and resize graphics 
 Format charts and diagrams

Collaborating
 Protect cells, worksheets, and workbooks 
 Apply workbook security settings 
 Share workbooks 
 Merge workbooks 
 Track, accept, and reject changes to workbooks

Managing Data and Workbooks
 Import data to Excel 
 Export data from Excel 
 Publish and edit Web worksheets and workbooks 
 Create and edit templates 
 Consolidate data 
 Define and modify workbook properties

Customizing Excel
 Customize toolbars and menus 
 Create, edit, and run macros 
 Modify Excel default settings

 

PowerPoint 2003 

Creating Content
 Create new presentations from templates 
 Insert and edit text-based content 
 Insert tables, charts and diagrams 
 Insert pictures, shapes and graphics 
 Insert objects

Formatting Content
 Format text-based content 
 Format pictures, shapes and graphics 
 Format slides 
 Apply animation schemes 
 Apply slide transitions 
 Customize slide templates 
 Work with masters

Collaborating
 Track, accept and reject changes in a presentation 
 Add, edit and delete comments in a presentation 
 Compare and merge presentations

Managing and Delivering Presentations
 Organize a presentation 
 Set up slide shows for delivery 
 Rehearse timing 
 Deliver presentations 
 Prepare presentations for remote delivery 
 Save and publish presentations 
 Print slides, outlines, handouts, and speaker notes 
 Export a presentation to another Microsoft Office program

 

Outlook 2003 

Messaging
 Organizing 
 Attach files to items 
 Create and modify a personal signature for messages 
 Modify e-mail message settings and delivery options 
 Create and edit contacts 
 Accept, decline, and delegate tasks

Scheduling
 Create and modify appointments, meetings, and events 
 Update, cancel, and respond to meeting requests 
 Customize Calendar settings 
 Create, modify, and assign tasks

Organizing
 Create and modify distribution lists 
 Link contacts to other items 
 Create and modify notes 
 Organize items 
 Organize items using folders 
 Search for items 
 Save items in different file formats 
 Assign items to categories 
 Preview and print items

 

Access 2003 

Structuring Databases
 Create Access databases 
 Create and modify tables 
 Define and modify field types 
 Modify field properties 
 Create and modify one-to-many relationships 
 Enforce referential integrity 
 Create and modify queries 
 Create forms 
 Add and modify form controls and properties 
 Create reports 
 Add and modify report control properties 
 Create a data access page

Entering Data
 Enter, edit and delete records 
 Find and move among records 
 Import data to Access

Organizing Data
 Create and modify calculated fields and aggregate functions 
 Modify form layout 
 Modify report layout and page setup 
 Format datasheets 
 Sort records 
 Filter records

Managing Databases
 Identify object dependencies 
 View objects and object data in other views 
 Print database objects and data
 Export data from Access 
 Back up a database 
 Compact and repair databases

 

Exam 70-601: Using Microsoft® Office Word 2007

1. Creating and Customizing Documents
    1.1. Create and format documents
    1.2. Lay out documents
    1.3. Make documents and content easier to find
    1.4. Personalize Office Word 2007.
2. Formatting Content
    2.1. Format text and paragraphs
    2.2. Manipulate text
    2.3. Control pagination
3. Working with Visual Content
    3.1. Insert illustrations
    3.2. Format illustrations
    3.3. Format text graphically
    3.4. Insert and modify text boxes
4. Organizing Content
    4.1. Structure content by using Quick Parts
    4.2. Use tables and lists to organize content
    4.3. Modify tables
    4.4. Insert and format references and captions
    4.5. Merge documents and data sources
5. Reviewing Documents
    5.1. Navigate documents.
    5.2. Compare and merge document versions
    5.3. Manage tracked changes
    5.4. Insert, modify, and delete comments
6. Sharing and Securing Content
    6.1. Prepare documents for sharing
    6.2. Control document access
    6.3. Attach digital signatures

 

Exam 70-602: Using Microsoft® Office Excel® 2007

1. Creating and Manipulating Data
    1.1. Insert data by using AutoFill
    1.2. Ensure data integrity
    1.3. Modify cell contents and formats
    1.4. Change Worksheet Views
    1.5. Manage worksheets
2. Formatting Data and Content
    2.1. Format worksheets
    2.2. Insert and modify rows and columns
    2.3. Format cells and cell content
    2.4. Format data as a table
3. Creating and Modifying Formulas
    3.1. Reference data in formulas
    3.2. Summarize data using a formula.
    3.3. Summarize data using subtotals.
    3.4. Conditionally summarize data by using a formula
    3.5. Look up data by using a formula.
    3.6. Use conditional logic in a formula.
    3.7. Format or modify text by using formulas.
    3.8. Display and print formulas.
4. Presenting Data Visually
    4.1. Create and format charts
    4.2. Modify charts
    4.3. Apply conditional formatting
    4.4. Insert and modify illustrations
    4.5. Outline data
    4.6. Sort and filter data
5. Collaborating and Securing Data
    5.1. Manage changes to workbooks
    5.2. Protect and share workbooks
    5.3. Prepare workbooks for distribution
    5.4. Save workbooks
    5.5. Set print options for printing data, worksheets, and workbooks

 

Exam 70-604: Using Microsoft® OfficeOutlook® 2007

1. Managing Messaging
    1.1. Create and send an e-mail message
    1.2. Create and manage your signature and automated messages
    1.3. Manage e-mail message attachments
    1.4. Configure e-mail message sensitivity and importance settings
    1.5. Configure e-mail message security settings
    1.6. Configure e-mail message delivery options
    1.7. View e-mail messages
2. Managing Scheduling
    2.1. Create appointments, meetings, and events
    2.2. Send meeting requests
    2.3. Update, cancel, and respond to meeting requests
    2.4. Customize calendar settings
    2.5. Share your Calendar with others
    2.6. View other calendars
3. Managing Tasks
    3.1. Create, modify, and mark tasks as complete
    3.2. Accept, decline, assign, update, and respond to tasks
4. Managing Contacts and Personal Contact Information
    4.1. Create and modify contacts
    4.2. Edit and use an electronic business card
    4.3. Create and modify distribution lists
    4.4. Create a secondary address book
5. Organizing Information
    5.1. Categorize Office Outlook 2007 items by color
    5.2. Create and manage Office Outlook 2007 data files
    5.3. Organize mail folders
    5.4. Locate Office Outlook 2007 items by using the search feature
    5.5. Create, modify and remove rules to manage e-mail messages
    5.6. Customize your Office Outlook 2007 Experience

 

Exam 70-605: Using Microsoft® Office Access 2007

1. Structuring a Database
    1.1. Define data needs and types
    1.2. Define and print table relationships
    1.3. Add, set, change, or remove primary keys
    1.4. Split databases
2. Creating and Formatting Database Elements
    2.1. Create databases
    2.2. Create tables
    2.3. Modify tables
    2.4. Create fields and modify field properties
    2.5. Create forms
    2.6. Create reports
    2.7. Modify the design of reports and forms
3. Entering and Modifying Data
    3.1. Enter, edit, and delete records
    3.2. Navigate among records
    3.3. Find and replace data
    3.4. Attach documents to and detach from records
    3.5. Import data
4. Creating and modifying queries
    4.1. Create queries
    4.2. Modify queries
5. Presenting and Sharing Data
    5.1. Sort data
    5.2. Filter data
    5.3. Create and modify charts
    5.4. Export data
    5.5. Save database objects as other file types
    5.6. Print database objects
6. Managing and Maintaining Databases
    6.1. Perform routine database operations
    6.2. Manage Databases

 

Exam 70-600: Windows Vista™ for the Business Worker

1. Protecting Your Computer
    1.1. Manage Windows Firewall.
    1.2. Manage malicious software (also called malware) protection.
    1.3. Configure Windows Update settings.
    1.4. Lock a computer.
    1.5. Manage Windows Internet Explorer security.
    1.6. Configure local user accounts.
2. Managing Mobile and Remote Computing
    2.1. Manage the computer power state.
    2.2. Manage network connections.
    2.3. Manage remote access to your computer.
    2.4. Connect to another computer.
    2.5. Access files stored in shared network folders when your computer is offline.
3. Managing Software, Disks, and Devices
    3.1. Manage software.
    3.2. Manage disks.
    3.3. Manage devices and drivers.
    3.4. Manage display settings.
    3.5. Configure multiple monitors.
    3.6. Install and configure a printer.
4. Managing Files and Folders
    4.1. Manage Windows Explorer settings.
    4.2. Manage and secure folders.
    4.3. Share folders.
    4.4. Search for files and folders.
    4.5. Organize files within folders.
    4.6. Manage files.
    4.7. Back up and restore files and folders.
5. Collaborating with Other People
    5.1. Collaborate in real time.
    5.2. Present information to an audience.
6. Customizing Your Windows Vista Experience
    6.1. Customize and modify the Start menu.
    6.2. Customize the taskbar.
    6.3. Personalize the appearance and sound of a computer.
    6.4. Manage the Windows Sidebar.
7. Optimizing and Troubleshooting Your Computer
    7.1. Increase processing speed.
    7.2. Locate troubleshooting information.
    7.3. Locate system information.
    7.4. Repair a network connection.
    7.5. Recover from software errors.
    7.6. Troubleshoot printing errors.
    7.7. Recover the operating system from a problem.
    7.8. Request and Manage Remote Assistance.

 

Exam 77-881: Word 2010
haring and Maintaining Documents
  • Apply different views to a document.
    • This objective may include but is not limited to: selecting zoom options, splitting and arranging windows (View Side by Side, Synchronous Scrolling), document views (reorganizing a document outline, master documents, subdocuments, web layout, draft), switching windows, opening a document in a new window
  • Apply protection to a document.
    • This objective may include but is not limited to: applying protection by using the Microsoft Office Backstage view commands (applying controls and restrictions to document access, password-protect a document, Mark as Final), applying protection by using ribbon commands
  • Manage document versions.
    • This objective may include but is not limited to: Recover draft versions, Delete all draft versions
  • Share documents.
    • This objective may include but is not limited to: sending documents via E-mail, SkyDrive, or internet fax, changing file types, creating PDF documents, creating and publishing a blog post, registering a blog account
  • Save a Document.
    • This objective may include but is not limited to: using compatibility mode, protected mode, and Save As options
  • Apply a template to a document.
    • This objective may include but is not limited to: finding templates (locating a template on your disk, finding templates on the web)
Formatting Content
  • Apply font and paragraph attributes.
    • This objective may include but is not limited to: Apply character attributes, apply styles, use Format Painter
  • Navigate and search through a document.
    • This objective may include but is not limited to: using the Navigation Pane (headings, pages, results), Go To, Browse by button, and Highlight features, and setting Find and Replace options (format, special)
  • Apply indentation and tab settings to paragraphs.
    • This objective may include but is not limited to: applying indents (first line, hanging), setting tabs, using the Tabs dialog box, setting tabs on the ruler, clearing tabs, setting tab stops, and moving tab stops
  • Apply spacing settings to text and paragraphs.
    • This objective may include but is not limited to: Line spacing, paragraph spacing
  • Create tables.
    • This objective may include but is not limited to: using the Insert Table dialog box, using Draw Table, inserting a Quick Table, converting text to tables, and using a table to control page layout
  • Manipulate tables in a document.
    • This objective may include but is not limited to: sorting content, adding a row to a table, adding a column to a table, splitting, merging, moving, resizing, and deleting a row or column, defining the header row, converting tables to text, and viewing gridlines
  • Apply bullets to a document.
    • This objective may include but is not limited to: applying bullets, selecting a symbol format, defining a picture to be used as a bullet, using AutoFormat, and promoting or demoting bullet levels
Applying Page Layout and Reusable Content
  • Apply and manipulate page setup settings.
    • This objective may include but is not limited to: setting margins, non-breaking spaces, hyphenation, and columns, working with breaks, forcing a page break, inserting a section break (continuous, Next page, Next Odd, Next Even), and inserting a blank page into a document
  • Apply themes.
    • This objective may include but is not limited to: Use a theme to apply formatting, customize a theme
  • Construct content in a document by using the Quick Parts tool.
    • This objective may include but is not limited to: adding built-in building blocks (quotes, text boxes, headers, footers, cover pages, watermarks, equations)
  • Create and manipulate page backgrounds.
    • This objective may include but is not limited to: formatting a document’s background, setting a colored background, adding a watermark, and placing page borders
  • Create and modify headers and footers.
    • This objective may include but is not limited to: inserting and formatting page numbers, inserting the current date and time, inserting a built-in header or footer, adding content to a header or footer (custom dialog box, manual entry), deleting a header or footer, changing margins, and applying a different first page atrribute
Including Illustrations and Graphics in a Document
  • Insert and format Pictures in a document.
    • This objective may include but is not limited to: adding captions, applying artistic effects and picture styles, compressing pictures, modifying a shape, adjusting position and size, and inserting screenshots
  • Insert and format shapes, WordArt, and SmartArt.
    • This objective may include but is not limited to: adding text to a shape, modifying text on a shape, adding captions, setting shape styles (border, text), and adjusting position and size
  • Insert and format Clip Art.
    • This objective may include but is not limited to: Organizing ClipArt, captions, artistic effects, compress pictures, corrections, modify the shape, reset, picture styles, arrange options, size
  • Apply and manipulate text boxes.
    • This objective may include but is not limited to: Format, save selection to text box gallery, text box styles, text direction, shadow effects, 3-D effects, arrange options
Proofreading documents
  • Validate content by using spelling and grammar checking options
    • This objective may include but is not limited to: Grammar and style options
  • Configure AutoCorrect settings
    • This objective may include but is not limited to: Add, remove, exceptions, AutoCorrect dialog
  • Insert and modify comments in a document
    • This objective may include but is not limited to: inserting a comment, editing a comment, deleting a comment, and viewing a comment (view comments from another user, view comments inline, view comments as balloons)
Applying References and Hyperlinks
  • Apply a hyperlink.
    • This objective may include but is not limited to: Hyperlink using text, hyperlink using graphic, headings and bookmarks, create new document, E-mail address
  • Create Endnotes and Footnotes in a document.
    • This objective may include but is not limited to: Manage footnote and endnote location, configure footnote and endnote format, presentation, and numbering
  • Create a Table of Contents in a document.
    • This objective may include but is not limited to: Default formats, show levels, alignment, tab leader, formats, options, modify styles, update table
Performing Mail Merge Operations
  • Setup mail merge
    • This objective may include but is not limited to: Perform a mail merge using the Mail Merge Wizard, perform a mail merge manually, Auto check for errors
  • Execute mail merge
    • This objective may include but is not limited to: Print, preview

Exam 77-887: Word Expert
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

Exam 77-882: Excel 2010
Managing the Worksheet Environment
  • Navigate through a worksheet.
    • This objective may include but is not limited to: Hot keys, name box
  • Print a worksheet or workbook.
    • This objective may include but is not limited to: printing only selected worksheets, printing an entire workbook, constructing headers and footers, and applying printing options (scale, print titles, page setup, print area, gridlines)
  • Personalize environment by using Backstage.
    • This objective may include but is not limited to: Manipulate the Quick Access Toolbar, manipulate the ribbon tabs and groups, manipulate Excel default settings, import data to Excel, import data from Excel, demonstrate how to manipulate workbook properties, manipulate workbook files and folders. apply different name and file formats for different uses by using save and save as features
Creating Cell Data
  • Construct cell data.
    • This objective may include but is not limited to: using paste special (formats, formulas, values, preview icons, transpose rows and columns, operations, comments, validation, paste as a link), and cutting, moving, and select cell data
  • Apply AutoFill.
    • This objective may include but is not limited to: Copy data using AutoFill, fill series using AutoFill, copy or preserve cell format with AutoFill, select from drop-down list
  • Apply and manipulate hyperlinks.
    • This objective may include but is not limited to: Create a hyperlink in a cell, modify hyperlinks, modify hyperlinked-cell attributes, remove a hyperlink
Formatting Cells and Worksheets
  • Apply and modify cell formats.
    • This objective may include but is not limited to: aligning cell content, applying a number format, wrapping text in a cell, and using Format Painter
  • Merge or split cells.
    • This objective may include but is not limited to: using Merge & Center, Merge Across, Merge cells, and Unmerge Cells
  • Create row and column titles.
    • This objective may include but is not limited to: Print row and column headings, print rows to repeat with titles, print columns to repeat with titles, configure titles to print only on odd or even pages, configure titles to skip the first worksheet page
  • Hide and unhide rows and columns.
    • This objective may include but is not limited to: Hide a column, unhide a column, hide a series of columns, hide a row, unhide a row, hide a series of rows
  • Manipulate Page Setup options for worksheets.
    • This objective may include but is not limited to: Configure page orientation, manage page scaling, configure page margins, change header and footer size
  • Create and apply cell styles.
    • This objective may include but is not limited to: Apply cell styles, construct new cell styles
Managing Worksheets and Workbooks
  • Create and format worksheets.
    • This objective may include but is not limited to: Insert worksheets, delete worksheets, copy, reposition, copy and move, rename, grouping, apply coloring to worksheet tabs, hiding worksheet tabs, unhiding worksheet tabs
  • Manipulate window views.
    • This objective may include but is not limited to: splitting window views, arranging window views, and opening a new window with contents from the current worksheet
  • Manipulate workbook views.
    • This objective may include but is not limited to: using Normal, Page Layout, and Page Break workbook views, and creating custom views
Applying Formulas and Functions
  • Create formulas.
    • This objective may include but is not limited to: Use basic operators, revise formulas
  • Enforce precedence.
    • This objective may include but is not limited to: Order of evaluation, precedence using parentheses, precedence of operators for percent vs. exponentiation
  • Apply cell references in formulas.
    • This objective may include but is not limited to: Relative, absolute
  • Apply conditional logic in a formula.
    • This objective may include but is not limited to: Create a formula with values that match your conditions, edit defined conditions in a formula, use a series of conditional logic values in a formula
  • Apply named ranges in formulas.
    • This objective may include but is not limited to: Define, edit and rename a named range
  • Apply cell ranges in formulas.
    • This objective may include but is not limited to: Enter a cell range definition in the formula bar, define a cell range using the mouse, define a cell range using a keyboard shortcut
Presenting Data Visually
  • Create charts based on worksheet data.
  • Apply and manipulate illustrations.
    • This objective may include but is not limited to: Clip Art, SmartArt, shapes, screenshots
  • Create and modify images by using the Image Editor.
    • This objective may include but is not limited to: making corrections to an image (sharpen or soften an image, changing brightness and contrast), using picture color tools, and changing artistic effects on an image
  • Apply Sparklines.
    • This objective may include but is not limited to: using Line, Column, and Win/Loss chart types, creating a Sparkline chart, customizing a Sparkline, formatting a Sparkline, and showing or hiding data markers
Sharing worksheet data with other users
  • Share spreadsheets by using Backstage.
    • This objective may include but is not limited to: sending a worksheet via E-mail or Skydrive, changing the file type to a different version of Excel, and saving as PDF or XPS
  • Manage comments.
    • This objective may include but is not limited to: inserting, viewing, editing, and deleting comments
Analyzing and Organizing Data
  • Filter data.
    • This objective may include but is not limited to: Define, apply, remove, search, filter lists using AutoFilter
  • Sort data.
    • This objective may include but is not limited to: using sort options (values, font color, cell color)
  • Apply conditional formatting.
    • This objective may include but is not limited to: Apply conditional formatting to cells, use the Rule Manager to Apply Conditional Formats, use the IF Function and Apply Conditional Formatting, icon sets, data bars, clear rules

Exam 77-888: Excel Expert
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

Exam 77-883: PowerPoint 2010
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
  • 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
  • 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
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
  • 8.2. 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
  • 8.4. 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

Exam 77-884: Outlook 2010
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