🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Business & Cross-Cutting › Bookkeeping / Office Administration › Certification Exam Preparation: QuickBooks Certified User, AIPB Certified Bookkeeper & Microsoft Office Specialist › Lesson 3
BUS-BOOK55-10 · Lesson 3 · 18 clock hours · lab

Domain-by-Domain Review: Microsoft Office Specialist (Excel, Word, Outlook)

Objective. Students perform each task category listed in the MOS exam objectives for Excel, Word, and Outlook at exam-level speed and accuracy, meeting the project-completion standards used in Certiport's performance-based MOS delivery format.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a credentialed professional in the field or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

Domain-by-Domain Review: Microsoft Office Specialist (Excel, Word, Outlook)

The Microsoft Office Specialist (MOS) credential is a performance-based certification delivered through Certiport. Unlike multiple-choice exams, MOS tests ask you to complete real tasks inside live Microsoft 365 applications. The testing engine records exactly what you do and scores each task independently. That format rewards accuracy, efficient navigation, and muscle memory built through repeated practice — not test-taking tricks.

This lab prepares you for the MOS exams in Excel, Word, and Outlook by working through every published skill domain at exam-level speed. The published MOS skill sets are freely available at microsoft.com/en-us/learning and should be your master checklist throughout this lesson.

---

Microsoft Excel: Core Skill Domains

Managing Worksheets and Workbooks. You must be able to create, rename, move, copy, hide, and delete worksheets. Practice switching between multiple open workbooks and using the View tab to freeze panes or split windows — tasks that appear consistently in published objectives.

Formatting Cells and Ranges. Apply number formats (currency, percentage, date), merge and center cells, use Format Painter, apply conditional formatting rules, and set cell styles. Pay attention to wrapping text and adjusting row height or column width, because the exam checks the exact resulting appearance.

Creating and Modifying Charts. Insert a recommended chart, then change the chart type, edit the data range, add or remove chart elements (title, legend, data labels), and apply chart styles. Know how to move a chart to its own sheet versus embedding it in the worksheet.

Building Formulas with Functions. The published objectives include — but are not limited to — SUM, AVERAGE, COUNT, COUNTA, IF, IFS, VLOOKUP, XLOOKUP (where listed), MIN, MAX, LEFT, RIGHT, and CONCAT. Practice entering these in cells, using absolute references with the dollar sign ($), and troubleshooting common errors such as #VALUE! and #REF!.

Managing Tables and Data. Convert a cell range to a table, sort and filter table data, add a total row, and apply table styles. Removing duplicates and using Flash Fill to reformat data are also tested skills.

---

Microsoft Word: Core Skill Domains

Document Formatting. Set page margins, orientation, paper size, and page breaks. Apply headers and footers with page numbers. Use the Design tab to set a theme or document colors. These changes must be applied to the whole document or specified sections only.

Styles and Paragraph Formatting. Apply built-in heading styles, modify a style's font or spacing, and create a multilevel list. Know how to use the Styles pane to find and replace formatting consistently across a document.

References and Navigation. Insert a table of contents based on heading styles, add footnotes or endnotes, insert a caption for a figure or table, and create a hyperlink. The exam may ask you to update an existing table of contents after content changes.

Mail Merge. Start a mail merge from the Mailings tab, connect a recipient list (usually an existing Excel table or Word table), insert merge fields into the document body, preview results, and complete the merge to a new document or printer. This is a multi-step process — practice the full workflow from start to finish.

Reviewing and Collaboration Tools. Track changes, accept or reject individual changes, insert and delete comments, and compare two versions of a document. Know how to lock or unlock Track Changes with a password only if that item appears in your specific exam version's objectives.

---

Microsoft Outlook: Core Skill Domains

Managing Email. Compose and send a message, attach files, set message flags, use CC and BCC correctly, create and apply categories, move messages to folders, and set up basic rules to automate sorting. Signature creation and reply/reply-all etiquette are also tested.

Calendar Management. Create appointments and recurring events, invite attendees (creating a meeting request), set reminders, and respond to meeting invitations. The exam checks that calendar items are saved with the correct date, time, and recurrence settings.

Tasks and Contacts. Create a task with a due date and priority level, mark tasks complete, and create or edit contact records including name, email, phone, and company fields. Know how to create a contact group (distribution list) from existing contacts.

---

Exam-Navigation Tips for the Certiport Environment

The Certiport testing system presents a task pane on one side of the screen while the live application is open on the other. Read each task instruction completely before touching the application. Tasks are scored independently — a mistake on task 3 does not prevent you from earning credit for task 4. If you are unsure how to complete a step, use the application's built-in Tell Me / Search bar to locate the command rather than spending time hunting through ribbons.

Manage your time actively. If a task is taking too long, skip and return. Most MOS exam forms allow you to return to unanswered tasks.

---

Safety and Professional Practice Notes

Office work carries ergonomic hazards. During long practice sessions at the computer, apply the 20-20-20 rule (every 20 minutes, look at something 20 feet away for 20 seconds), position monitors at eye level, and keep wrists in a neutral position to reduce repetitive strain risk. Report any workstation discomfort to your instructor so equipment can be adjusted before a real injury develops. Protect student practice files by saving to designated folders only — never save to shared drives or cloud locations that could expose personally identifiable information.

---

Rubric and Pass Standard

Each of the three timed practice projects is graded on task-level accuracy using a rubric aligned to the published MOS skill sets. You must complete at least 80% of tasks correctly within the allotted time to pass a block. If you score below 80% on any application, you will complete one targeted drill file and be re-evaluated before moving to the mock exam lesson. Track your task-level scores after every GMetrix session or practice project so you can direct your remaining study time to the domains where you are weakest.

Key terms10

Performance-Based ExamA certification test format in which candidates complete real tasks inside a live application rather than answering multiple-choice questions; the testing engine grades the actual file state.
MOS Skill Set (Exam Objectives)The official published list of task categories and specific skills that Microsoft releases for each MOS exam; this document is the definitive checklist for what may be tested.
CertiportThe authorized test-delivery platform used to administer Microsoft Office Specialist and other Intuit and industry certification exams at approved testing centers.
Absolute Cell ReferenceA formula reference that does not change when the formula is copied to another cell; created by placing a dollar sign before the column letter and row number (e.g., $B$4).
VLOOKUPAn Excel function that searches the first column of a table range for a value and returns a result from a specified column in the same row; a core function tested in the MOS Excel exam.
Mail MergeA Word feature that combines a main document (such as a form letter) with a data source (such as an Excel table) to produce individualized copies for each recipient.
Track ChangesA Word reviewing feature that records every insertion, deletion, or formatting change made to a document so that another user can accept or reject each edit individually.
Conditional FormattingAn Excel feature that automatically applies cell formatting — such as color fills or icon sets — based on rules or formulas applied to the cell's value.
Contact Group (Distribution List)An Outlook feature that stores multiple email addresses under a single name, allowing a user to send one message to all members of the group simultaneously.
Table of Contents (TOC)A Word reference feature that automatically generates a navigable list of document headings and their page numbers based on applied heading styles; can be updated when content changes.
In class: Instructor leads three structured review blocks (one per application) using the published MOS exam skill sets: for Excel, students practice managing worksheets, formatting cells and ranges, creating and modifying charts, building formulas with functions (SUM, AVERAGE, IF, VLOOKUP, and others appearing in published objectives), and managing tables and data; for Word, students practice document formatting, styles, references, mail merge, and reviewing tools; for Outlook, students practice managing email, calendar, tasks, and contacts — each block includes a timed, task-based practice project graded against a rubric derived from published MOS skill sets. · Students complete GMetrix or equivalent MOS practice exam sessions (or instructor-created task project files if GMetrix is unavailable) for each application, recording their task-level scores to identify remaining weak skills; students then complete focused skill-drill files targeting any task category below 80% accuracy. · Students pair up and conduct peer evaluations: one student performs a randomly assigned MOS task list while the partner uses the rubric to score accuracy and completion, then roles reverse; pairs discuss errors, and instructor circulates to clarify correct application behavior and exam-navigation tips specific to the Certiport testing environment.
Materials: Microsoft 365 (Excel, Word, Outlook — student access); published Microsoft MOS exam skill sets (available at microsoft.com/en-us/learning); GMetrix MOS practice platform (or instructor-prepared task project files as substitute); MOS task rubrics (instructor-prepared, aligned to published skill sets); student computers
Check: Three timed task-based practice projects (one per application) scored against MOS-aligned rubrics; pass mark is 80% of tasks completed correctly within the allotted time for each application; students scoring below 80% on any application complete one additional targeted drill project and are re-evaluated before advancing to the mock exam lesson.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

Microsoft Office Specialist — Exam Navigation
1. In the Certiport MOS testing environment, if you are unsure how to complete a task, the most productive immediate action is to:
Microsoft Office Specialist — Excel: Formulas and Functions
2. A student wants the formula =B2*C2 to always reference cell C2 regardless of where the formula is copied. Which formula correctly locks only column C, row 2?
Microsoft Office Specialist — Excel: Formulas and Functions
3. Which Excel function looks up a value in the first column of a range and returns a value in the same row from a column you specify?
Microsoft Office Specialist — Word: Mail Merge
4. When completing a mail merge in Word, what is the correct sequence of main steps?
Microsoft Office Specialist — Word: References
5. A Word document's table of contents was generated from heading styles. After adding two new sections with Heading 1 style, the author needs the TOC to reflect the new sections. What is the correct action?
Microsoft Office Specialist — Outlook: Calendar Management
6. In Outlook, a colleague sends you a meeting invitation for next Tuesday at 10:00 AM. To inform the organizer that you will attend, you should:
Microsoft Office Specialist — Excel: Formatting Cells and Ranges
7. An Excel worksheet contains a table of sales data. A student applies a conditional formatting rule to highlight any cell in column D where the value is greater than 5000 in green fill. After applying the rule, a cell showing 4999 is green. What is the most likely cause?
Microsoft Office Specialist — Program Assessment Policy
8. According to the MOS lab pass standard in this lesson, a student who scores 75% on the timed Word practice project must:
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.
← Previous lessonProgram planNext lesson →