|
Microsoft Office Specialist Program
Microsoft Office
Specialist
The Microsoft Office Specialist program measures your expertise
in Microsoft desktop applications and provides a credential to prove it!
This unique certification is a globally accepted standard
that identifies the level of a user's proficiency in Microsoft Office
applications.
MOUS certification is obtainable by successfully completing the exam
for any of the following courses.
Excel 2000 Core
Description
Exam objectives
Exam objectives are categories of examination tasks, identified by
subject-matter experts, that certify an ability to productively use
Microsoft Office applications. These categories are organized into
skill sets representing the more basic functions of each Office
application.
Exam objectives and skill sets for the Microsoft Excel 2000 Core
Exam are provided below to assist in your exam preparation. Training
centers and courseware providers authorized by the Microsoft Office
Specialist (Office Specialist) program tailor their instruction to
these criteria.
Working with Cells
- Use Undo and Redo
- Clear cell content
- Enter text, dates, and numbers
- Edit cell content
- Go to a specific cell
- Insert and delete selected cells
- Cut, copy, paste, paste special, and move selected cells
- Use the Office Clipboard
- Use Find and Replace
- Clear cell formats
- Work with series (AutoFill)
- Create hyperlinks
Working with Files
- Use Save
- Use Save As (different name, location, and format)
- Locate and open an existing workbook
- Create a folder
- Use templates to create a new workbook
- Save a worksheet/workbook as a Web Page
- Send a workbook via e-mail
- Use the Microsoft Office Assistant
Formatting Worksheets
- Apply font styles (typeface, size, color, and styles)
- Apply number formats (currency, percent, dates, and commas)
- Modify row and column size
- Modify alignment of cell content
- Adjust decimal places
- Use the Format Painter
- Apply autoformat
- Apply cell borders and shading
- Merge cells
- Rotate text and change indents
- Define, apply, and remove a style
Page Setup and Printing
- Preview and print worksheets and workbooks
- Use Web Page Preview
- Print a selection
- Change page orientation and scaling
- Set page margins and centering
- Insert and remove a page break
- Set print, and clear a print area
- Set up headers and footers
- Set print titles and options (gridlines, print quality, and
headings for rows and columns)
Working with Worksheets and Workbooks
- Insert and delete rows and columns
- Hide and unhide rows and columns
- Freeze and unfreeze rows and columns
- Change the zoom setting
- Move between worksheets in a workbook
- Check spelling
- Rename a worksheet
- Insert and delete worksheets
- Move and copy worksheets
- Link worksheets and consolidate data using 3-D references
Working with Formulas and Functions
- Enter a range within a formula in a drag-and-drop operation
- Enter formulas in a cell and use the formula bar
- Revise formulas
- Use references (absolute and relative)
- Use AutoSum
- Use the Paste Function to insert a function
- Use basic functions (AVERAGE, SUM, COUNT, MIN, and MAX)
- Enter functions using the Formula Palette
- Use date functions (NOW and DATE)
- Use financial functions (FV and PMT)
- Use logical functions (IF)
Using Charts and Objects
- Preview and print charts
- Use the Chart Wizard to create a chart
- Modify charts
- Insert, move, and delete an object (graphic)
- Create and modify lines and objects
Word
2000 Core
Description
Exam Objectives
Exam objectives are categories of
examination tasks, identified by subject-matter experts, that
certify an ability to productively use Microsoft Office
applications. These categories are organized into skill sets
representing the more basic functions of each Office
application.
Exam objectives and skill sets for the Microsoft Word 2000
Core Exam are provided below to assist in your exam
preparation. Training centers and courseware providers
authorized by the Microsoft Office Specialist (Office
Specialist) program tailor their instruction to these
criteria.
Working with Text
- Use the Undo, Redo, and Repeat commands
- Apply font formats (bold, italic, and underline)
- Use the Spelling and Grammar command
- Use the Thesaurus
- Insert page breaks
- Highlight text in document
- Insert and move text
- Cut, copy, paste, and paste special using the Office
Clipboard
- Copy formats using the Format Painter
- Select and change font and font size
- Find and replace text
- Apply character effects (superscript, subscript,
strikethrough, small caps, and outline)
- Insert date and time
- Insert symbols
- Create and apply frequently used text with AutoCorrect
Working with Paragraphs
- Align text in paragraphs (center, left, right, and
justified)
- Add bullets and numbering
- Set character, line, and paragraph spacing options
- Apply borders and shading to paragraphs
- Use indentation options (left, right, first line, and
hanging indent)
- Use Tabs command (center, decimal, left, and right)
- Create an outline-style numbered list
- Set tabs with leaders
Working with Documents
- Print a document
- Use print preview
- Use Web Page Preview
- Navigate through a document
- Insert page numbers
- Set page orientation
- Set margins
- Use GoTo to locate specific elements in a document
- Create and modify page numbers
- Create and modify headers and footers
- Align text vertically
- Create and use newspaper columns
- Revise column structure
- Prepare and print envelopes and labels
- Apply styles
- Create sections with formatting that differs from other
sections
- Use Click and Type
Managing Files
- Use save
- Locate and open an existing document
- Use Save As (different name, location, or format)
- Create a folder
- Create a new document using a wizard
- Save as Web Page
- Use templates to create a new document
- Create Hyperlinks
- Use the Microsoft Office Assistant
- Send a Word document via e-mail
Using Tables
- Create and format tables
- Add borders and shading to tables
- Revise tables (insert and delete rows and columns and
change cell formats)
- Modify table structure (merge cells, change height, and
width)
- Rotate text in a table
Working with Pictures and Charts
- Use the drawing toolbar
- Insert graphics into a document (WordArt, clip art, and
images)
Access 2000 Core
Description
Exam objectives
Exam objectives are categories of examination tasks, identified by
subject-matter experts, that certify an ability to productively use
Microsoft Office applications. These categories are organized into
skill sets representing the more basic functions of each Office
application.
Exam objectives and skill sets for the Microsoft Access 2000 Core
Exam are provided below to assist in your exam preparation. Training
centers and courseware providers authorized by the Microsoft Office
Specialist (Office Specialist) program tailor their instruction to
these criteria.
Planning and Designing Databases
- Determine appropriate data inputs/outputs for your database
- Create table structure
- Establish table relationships
Working with Access
- Use the Microsoft Office Assistant
- Select an object using the Objects Bar
- Print database objects (tables, forms, reports, and queries)
- Navigate through records in a table, query, or form
- Create a database (using a wizard or in-design view)
Building and Modifying Tables
- Create tables by using the Table Wizard
- Set primary keys
- Modify field properties
- Use multiple data types
- Modify tables using Design View
- Use the Lookup Wizard
- Use the Input Mask Wizard
Building and Modifying Forms
- Create a form with the Form Wizard
- Use the Control Toolbox to add controls
- Modify Format Properties (font, style, font size, color,
caption, etc.) of controls
- Use form sections (headers, footers, and detail)
- Use a Calculated Control on a form
Viewing and Organizing Information
- Use the Office Clipboard
- Switch between object views
- Enter records using a datasheet
- Enter records using a form
- Delete records from a table
- Find a record
- Sort records
- Apply and remove filters (filter by form and filter by
selection)
- Specify criteria in a query
- Display related records in a subdatasheet
- Create a calculated field
- Create and modify a multitable select query
Defining Relationships
- Establish relationships
- Enforce referential integrity
Producing Reports
- Create a report with the Report Wizard
- Preview and print a report
- Move and resize a control
- Modify Format Properties (font, style, font size, color,
caption, etc.)
- Use the Control Toolbox to add controls
- Use report sections (headers, footers, and detail)
- Use a Calculated Control in a report
Integrating with Other Applications
- Import data to a new table
- Save a table, query, or form as a Web page
- Add Hyperlinks
Using Access Tools
- Print database relationships
- Back-up and restore a database
- Compact and repair a database
PowerPoint
2000 Core
Description
Exam objectives
Exam objectives are categories of examination tasks, identified by
subject-matter experts, which certify an ability to productively use
Microsoft Office applications. These categories are organized into
skill sets representing the more basic functions of each Office
application.
Exam objectives and skill sets for the Microsoft PowerPointŪ 2000
Core Exam are provided below to assist in your exam preparation.
Training centers and courseware providers authorized by the Microsoft
Office Specialist (Office Specialist) program tailor their instruction
to these criteria.
Creating a Presentation
- Delete slides
- Create a specified type of slide
- Create a presentation from a template or a wizard
- Navigate among different views (slide, outline, sorter, and
tri-pane)
- Create a new presentation from existing slides
- Copy a slide from one presentation into another
- Insert headers and footers
- Create a blank presentation
- Create a presentation using the AutoContent Wizard
- Send a presentation via e-mail
Modifying a Presentation
- Change the order of slides using Slide Sorter view
- Find and replace text
- Change the layout for one or more slides
- Modify the Slide Master
- Modify slide sequence in the outline pane
- Apply a design template
Working with Text
- Check spelling
- Change and replace text fonts (individual slide and entire
presentation)
- Enter text in tri-pane view
- Import text from Microsoft Word
- Change the text alignment
- Create a text box for entering text
- Use the Wrap text in TextBox feature
- Use the Office Clipboard
- Use the Format Painter
- Promote and Demote text in slide and outline panes
Working with Visual Elements
- Add a picture from the Clip Art Gallery
- Add and group shapes using WordArt or the Drawing Toolbar
- Apply formatting
- Add text to a graphic object using a text box
- Scale and size an object including clip art
- Create tables within PowerPoint
- Rotate and fill an object
Customizing a Presentation
- Add AutoNumber bullets
- Add speaker notes
- Add graphical bullets
- Add slide transitions
- Animate text and objects
Creating Output
- Preview presentation in black and white
- Print slides in a variety of formats
- Print audience handouts
- Print speaker notes in a specified format
Delivering a Presentation
- Start a slide show on any slide
- Use on screen navigation tools
- Print a slide as an overhead transparency
- Use the pen during a presentation
Managing Files
- Save changes to a presentation
- Save as a new presentation
- Publish a presentation to the Web
- Use the Microsoft Office Assistant
- Insert hyperlink
|
Infotech