Certifications‎ > ‎


Microsoft Office Specialist Certification

MS Office Specialist

Step 1: Key Applications

Before doing any MOS assignments, complete the Key Applications assignmments.

Step 2:  Pearson E-Book

  1. Create an account at http://www.pearsoncustom.com/us/MSOffice2010/ 
  2. Follow these instructions to enroll in the Office 2010 course:
  3. Access Code: Available in Room C236 
  4. Course Code: Available in Room C236
  5. Course name: Tech Certifications MOS 2010 Pearson
  6. Complete the "Grader" "Homework" projects for the MOS certificate of your choice.
  7. Submit completed file to Pearson for automatic grading. Each may be corrected and submitted up to five times
  8. Tip:  Take notes as you learn new features you won't want to forget.  This will  make it much easier to study for the MOS exams.
  9. Each week you should have at least one grader project completed.
  10. To help complete the Grader Projects, follow these videos.

Step 3: GMetrix Practice Tests

  • Complete the GMetrix Practice Tests.  Codes are available in Room C236.

What's Covered

General MS Office

These general  topics are in most MS Office exams:
  1. Format (font, paragraph, page setup...)
  2. Advanced format (Format painter, styles, themes…)
  3. Present information in tables and charts
  4. Create and format multi-level lists
  5. Insert and format graphics (pictures, SmartArt, shapes, clip art, WordArt)

MS Word

  1. Construct reusable content (AutoCorrect, Quick Parts, templates)
  2. Work with multi-page documents (table of contents, footnotes/endnotes, index, page numbers, headers/footers)
  3. Perform mail merge
  4. Compare documents (accept/reject changes...)

MS Excel

  1. Use AutoFill
  2. Format cells and tables (styles, borders, fill, number, indent, alignment, merge cells, split cells, column width, row height ...)
  3. Manipulate views (hide/unhide columns and rows, split screen, freeze, view multiple sheets)
  4. Create formulas (Understand order of operations and absolute reference)
  5. Use functions (IF, SUM, AVERAGE…)
  6. Apply named ranges in formulas
  7. Visually present data (sparklines, conditional formatting, charts)
  8. Import or export data
  9. Use Text to Columns feature
  10. Summarize and analyze data (filter, sort, pivot table, consolidate, group)

MS PowerPoint

  1. Use presentation features to communicate effectively
  2. Construct and edit a Photo Album
  3. Add, remove, and rearrange slides
  4. Import slides from another presentation
  5. Create and apply Slide Master layouts
  6. Insert audio and video content
  7. Apply transitions and animations

MS Access

  1. Create tables, records, and fields
  2. Set relationships
  3. Create and manage queries to sort, filter, and summarize data
  4. Create calculated fields
  5. Import or export data
  6. Create reports