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 |
| Certificate Validity Period: | No expiration |
| Exam Duration: | 50 minutes |
| Exam Price: | $100 USD |
| Real Exam Qty: | 35-50 |
| Available Languages: | English |
| Related Certifications: | Microsoft Office Specialist: Associate (Microsoft 365 Apps) |
| Exam Format: | Performance-based |
| Passing Score: | 700/1000 |
| 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: Perform Operations by Using Formulas and Functions | 20-25% | - Perform conditional operations
|
| Topic 2: Manage Worksheets and Workbooks | 10-15% | - Import data into workbooks
|
| Topic 3: Manage Data Cells and Ranges | 20-25% | - Manipulate data in worksheets
|
| Topic 4: Manage Tables and Table Data | 15-20% | - Modify tables
|
| Topic 5: Manage Charts | 20-25% | - Create charts
|
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:
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 1:
Add Open to the Quick Access Toolbar.
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:
Car Warranty
You are the supervisor for a Car Warranty Center. You use Excel to report employee hours and telephone calls.
Task 2:
On the Employee Hours worksheet, add a row to the table that automatically calculates total hours worked by all employees.
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:
Clearance Sale
You are the administrative assistant for a retail company that is going out of business. You've been tasked to prepare a workbook for the clearance sale.
Task 4:
On the Sold worksheet, format the table so that every other row is shaded. Use a technique that automatically updates the formatting if you insert a newrow.
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:
Clearance Sale
You are the administrative assistant for a retail company that is going out of business. You've been tasked to prepare a workbook for the clearance sale.
Task5:
On the Vehicles worksheet, in the Code column cell B4, create a formula that returns the two leftmost letters of the vehicle style displayed in cell D4.
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 Karen
