We're so confident of our products that we provide no hassle product exchange.
Microsoft MO-210 Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | Microsoft Excel (Microsoft 365 Apps) |
| Exam Number: | MO-210 |
| Related Certifications: | Microsoft Office Specialist: Associate (Microsoft 365 Apps) |
| Available Languages: | English |
| Exam Price: | $100 USD |
| Exam Format: | Performance-based |
| Certificate Validity Period: | No expiration |
| Passing Score: | 700/1000 |
| Exam Duration: | 50 minutes |
| Real Exam Qty: | 35-50 |
| Sample Questions: | Microsoft MO-210 Sample Questions |
| Exam Way: | Online proctored or in-person at authorized Certiport testing centers. |
| Pre Condition: | No formal prerequisite. Recommended to have approximately 150 hours of instruction and hands-on experience with Microsoft Excel. |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/mos-excel-associate-m365-apps/ |
Microsoft MO-210 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Manage Worksheets and Workbooks | 10-15% | - Customize options and views
|
| Topic 2: Manage Charts | 20-25% | - Create charts
|
| Topic 3: Manage Data Cells and Ranges | 20-25% | - Define and reference named ranges
|
| Topic 4: Manage Tables and Table Data | 15-20% | - Filter and sort table data
|
| Topic 5: Perform Operations by Using Formulas and Functions | 20-25% | - Perform conditional operations
|
Microsoft Excel (Microsoft 365 Apps) Sample Questions:
1. Instructions
Exam Environment
Exam Interface and Controls
The exam panel provides access to the project task(s). Each project has an associated file in which you will perform the project tasks.
Overview:
Guitar Stores
You and a partner own several Guitar Stores. You are analyzing your revenue from the past two quarters.
Task5:
Display the formulas that are in the cells of the Qtr 2 worksheet.
2. Instructions
Exam Environment
Exam Interface and Controls
The exam panel provides access to the project task(s). Each project has an associated file in which you will perform the project tasks.
Overview:
Jelly Beans
A shop you manage sells gourmet jelly beans. You are tracking the amount of jelly beans sold each quarter and summarizing the information in aworkbook.
Task 4:
Filter the Profits worksheet to display only flavors with Total Profit that are Above Average.
3. Instructions
Exam Environment
Exam Interface and Controls
The exam panel provides access to the project task(s). Each project has an associated file in which you will perform the project tasks.
Overview:
Motorhome Rentals
Your company rents motorhomes. The motorhomes rent year-around at different prices. You are preparing pricing worksheets to be shared with others.
Task 3:
Set cells A1:F11 so they will be the only cells that print.
4. Instructions
Exam Environment
Exam Interface and Controls
The exam panel provides access to the project task(s). Each project has an associated file in which you will perform the project tasks.
Overview:
Motorhome Rentals
Your company rents motorhomes. The motorhomes rent year-around at different prices. You are preparing pricing worksheets to be shared with others.
Task 2:
Add the value New Rates to the Title property of the document.
Solutions:
| Question # 1 Answer: Only visible for members | Question # 2 Answer: Only visible for members | Question # 3 Answer: Only visible for members | Question # 4 Answer: Only visible for members |
By Harriet
