Microsoft Office Specialist: Excel

Exam Prep
Associate

Study Guide
Educator Introduction
Microsoft License Terms
This courseware is the copyrighted work of Microsoft and/or its suppliers, and is licensed, not
sold, to you. Microsoft grants you a license to use this courseware, but only in accordance
with the “Guidelines” below. Except as expressly provided for herein, you may not copy,
adapt, modify, prepare derivative works of, distribute, publicly display, sell or use this
courseware, in whole or in part, for any commercial purpose without the express prior
written consent of Microsoft Corporation.
This courseware is provided to you “as-is.” Microsoft makes no warranties as to this
courseware, express or implied. MICROSOFT CORPORATION HEREBY DISCLAIMS ALL
WARRANTIES AND CONDITIONS WITH REGARD TO THE SOFTWARE, INCLUDING ALL
WARRANTIES AND CONDITIONS OF MERCHANTABILITY, WHETHER EXPRESS, IMPLIED OR
STATUTORY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NON-INFRINGEMENT.
Microsoft may change or alter the information in this courseware, including URL and other
Internet Web site references, without notice to you.
Examples depicted herein are provided for illustration purposes only and are fictitious. No
real association or connection is intended or should be inferred.
This courseware does not provide you with any legal rights to any intellectual property in or
to any Microsoft products.
The Microsoft Terms of Use are incorporated herein by reference.
Guidelines
This courseware is only for use by instructors and only to teach a class, not for commercial
use. If you are not an instructor, you are not permitted to use this courseware. The following
terms apply to your use of this courseware:
 You may distribute this courseware only to those students enrolled in your class
using the courseware, or publish this courseware on a secured website that is
restricted to students enrolled in that class, provided that if you distribute this
courseware:
 you will not grant any rights to copy, adapt, modify, prepare derivative works
of, distribute, publicly display, or sell this courseware.
 you may not distribute this courseware under terms that would permit
commercial use, or under terms that purport to require that this courseware,
in whole or in part, be sublicensed to others or redistributable at no charge;
and
 you will maintain and not alter, obscure or remove any copyright or other
protective notices, identifications or branding in or on the courseware.
© 2022 Microsoft. All rights reserved.

Table of Content
s
Microsoft License Terms..................................................................................2

About this Study Guide..........................................................................5

Study Guide Features.........................................................................5

Scenario.......................................................................................5

Projects..........................................................................................5

Data Files/Media Files....................................................................6

Learning Directory...........................................................................6

Solution Files...................................................................................6

How to use this Study Guide...............................................................6

Structure...........................................................................................7

Scenario..........................................................................................7

Instructional Methods and Strategies................................................7

Software Requirements.........................................................................9

Additional Information and Resources....................................................9

Certification................................................................................................9
 About this Study Guide
Welcome to the Microsoft Office Specialist: Excel Associate Certification
Exam Prep Study Guide. This Exam Prep Study Guide is for use by educators
to help students practice and prepare for the Excel (Microsoft 365 Apps):
Exam MO-210 certification exam. The Study Guide can be either educator or
student-led and provides flexibility for both classroom and remote learning
environments.

This Study Guide includes three 50-minute hands-on projects to help

students assess their readiness for the certification exam. These scenario-
based projects consist of multiple real-world tasks that map to exam
objectives. Accompanying the projects is the Learning Directory which allows
students to research and practice specific concepts until mastery. Solution
files are provided for educators to assess and remediate student progress.
The Study Guide is available in three different file formats allowing educators
to select the format that is the best fit for their learning environment.

Study Guide Features

The following features were designed and structured to support students’
achievement of the Excel (Microsoft 365 Apps): Exam MO-210 exam
objective domains.

Scenario
This Study Guide uses a single business scenario that unifies all the project
tasks and gives students a single focus for applying what they learn. As
students complete the tasks, they will experience Microsoft Apps through the
lens of a real-world setting. They will be challenged to become more
productive and efficient users of Microsoft Apps while navigating common
workplace responsibilities.

Projects
The Study Guide is divided into three different projects. Projects include a set
of up to 40 tasks to be completed within approximately 50 minutes to
simulate the certification exam environment. Based on exam, each task
addresses specific objectives to assess students’ knowledge of the
application in a real-world context.
 Data Files/Media Files
The Student Materials folder contain three Project File folders with all data
and media files. These resources are the starter and supporting files that
students will use to complete the projects.

Learning Directory
The Learning Directory provides a table with certification exam objectives,
online resources, step-by-step guidance for remediation of the skills covered,
along with mapping to the Study Guide projects. This directory helps
students focus on specific concepts to improve their competency with
Microsoft Excel.

Solution Files
The Educator Materials folder contains solution files for each project that
demonstrate a successful solution for completing the tasks and projects.
These solutions are provided in multiple formats to allow for differentiation.

There are three solution file types for each project:

 Project_StepbyStepSolution.docx - instructions for completing each
task
 Project_VideoStepbyStepSolution.pptx - a video demonstration of
how to complete each task. Note, this solution is for demonstration
only and does not provide audio. For students who need audio, they
can use the Project_StepbyStepSolution with Microsoft Accessibility
tools.
 Project_SolutionFile.xlsx - a completed solution file providing a
sample of the successful project solution

Teachers can use these files as a guide and share solutions with students at
their discretion.

How to use this Study Guide

The following section provides information on the structure of materials,
project scenario, and suggested instructional methods and strategies.
 Structure
Below is an overview of the folder structure and materials within the Student
Study Guide.

Educator Materials
This folder contains the following files:
 Introduction_Educator.docx – introduction and details for the
educator
 Project_SolutionFiles – solutions in multiple formats for each project
including:
 Project_StepbyStepSolution.docx
 Project_VideoStepbyStepSolution.pptx
 Project_SolutionFile.docx

Student Materials
This folder contains the Study Guide in a PDF e-book and individual Excel
files to allow educators to customize the materials to fit their needs. The
Project Files support both options.
 StudentStudyGuide_PDF.pdf – Introduction, Student projects, and
Learning Directory compiled in one PDF file
 StudentStudyGuide_ExcelDocumentVersion – Student Study Guide
PDF available as individual customizable Excel documents
 Project_Files – supporting data and media files needed to complete
projects

Scenario
This Study Guide utilizes Munson’s Pickles and Preserves Farm as the
overarching scenario for all project tasks. In this business scenario, Munson’s
Pickles and Preserves started as a small farm market focused on fresh
produce. Due to the success of the business, coupled with the family’s
passion for greenery, Munson’s is now considering expanding the business to
include a flower and plant nursery.
Students completing the projects in this study guide will envision themselves
as a Munson’s Pickles and Preserves Farm employee tasked with evaluating
and researching the potential flower and plant nursery expansion. They will
then present their collected research and data to Munson’s to guide the
future development and expansion of the farm.

Instructional Methods and Strategies

The following includes suggested methods and strategies for utilizing this
Study Guide:
  Each project covers approximately 35 exam objectives allowing ample
opportunity for students to prepare for the exam.
 Students should download all project data and media files before
beginning tasks. Teachers can determine the best location for students
to download the project data and media files (e.g., download from
Canvas).
 Before beginning each project task, encourage the students to read the
instructions in the Student Materials carefully to ensure the task is
performed correctly.
 Encourage students to use the checkbox provided for each project task
as an organizational tool to track completion.
 The three projects collectively cover all Microsoft Excel (Microsoft 365
Apps) objective domains. To ensure all students practice all exam
objectives, students should complete all three projects.
 Consider timing students during task completion to simulate the
testing environment.
 Students can complete projects in varied formats and environments.
For example, ask students to demonstrate tasks for an audience/class
or place students in small groups to complete tasks or projects.
 Multiple Study Guide solution files allow for differentiated assessment
methods including self-assessment and traditional teacher-led
assessment. Students can compare completed projects with the
project solution, view the video demonstration, or review the project
step-by-step.
 If students have difficulty completing a task, they can utilize the
Learning Directory to research and practice specific concepts until
mastery.
 Implement remote and self-paced learning by referencing the
comprehensive Learning Directory.

The following are suggested tips for educators:

 There are multiple ways to complete each project task. The Learning
Directory and solution files may only address one or two options for
completion. It should be noted there may be other ways to complete
the task effectively and correctly.
 If teachers use projects or tasks as assessment, they may choose to
delete the reference to the Learning Directory in the project
instructions.
 If a project task instructs the student to enter “specific text,” the
student should not include the comma inside the quotations.
 When completing project tasks that include formulas and functions,
students should enter the formula and/or function rather than copying
and pasting text.
 Encourage students to utilize the Insert Function dialog box. This is a
helpful tool that will simplify using functions in project tasks.
 If dual monitors are available, instruct students to follow the course on
one monitor and engage in project activities on the other.
 Students will need to save their work. Ensure students have a location
where they can save their projects (USB drive, school share, OneDrive).
 Software Requirements
In preparation for using this Study Guide, ensure that all students have a
computer with:
 Microsoft 365 Apps

This Study Guide contains direct mapping of the content to the objective
domain for the Excel (Microsoft 365 Apps): Exam MO-210. This exam, like all
Microsoft Office Specialist certification exams, is based on desktop
application features that only come with Microsoft 365 Apps.

Additional Information and Resources

Certification
 To learn more about the Excel (Microsoft 365 Apps): Exam MO-210,
visit MOS Excel: Certifications
 To learn more about Microsoft certifications, visit Microsoft
Certification