The purpose of this Sample Question Set is to provide you with information about the Microsoft Excel Expert - Microsoft 365 Apps exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the MO-211 certification test. To get familiar with real exam environment, we suggest you try our Sample Microsoft Excel Expert 365 Apps Certification Practice Exam. This sample practice exam gives you the feeling of reality and is a clue to the questions asked in the actual Microsoft Office Specialist - Excel Expert (Microsoft 365 Apps) certification exam.
These sample questions are simple and basic questions that represent likeness to the real Microsoft MO-211 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium Microsoft Excel Expert 365 Apps Certification Practice Exam. When you solve real time scenario based questions practically, you come across many difficulties that give you an opportunity to improve.
Microsoft MO-211 Sample Questions:
01. How can you make a cell turn green if the value is greater than 100 using conditional formatting?
a) Set a simple rule for greater than 100
b) Use a custom formula
c) Apply a green fill to all cells then set exceptions for those not greater than 100
d) Conditional formatting cannot achieve this
02. To manage workbook versions efficiently, which feature should be activated?
a) Track Changes
b) Autosave
c) Archive
d) Version History
03. Which function can be used in a formula to apply conditional formatting based on whether a cell's date is past?
a) TODAY()
b) NOW()
c) DATE()
d) DAY()
04. What features can you add to a PivotTable to enhance its analytical capabilities?
(Choose Three)
a) Slicers
b) Data bars
c) Calculated fields
d) Conditional formatting
e) External data connections
05. Data Validation can be used to create a dropdown list of valid inputs, which enhances ______.
a) speed
b) usability
c) formatting
d) complexity
06. Which of the following functions would you use to perform complex data matches and retrievals?
(Choose Two)
a) XLOOKUP()
b) VLOOKUP()
c) INDEX()
d) CONCATENATE()
07. When creating a dual-axis chart, which scenarios are most appropriate?
(Choose Two)
a) Comparing different units of measure
b) Showing relationships between two variables
c) Displaying single sets of data
d) Illustrating part-to-whole relationships
08. Managing multiple conditional formatting rules is done in the ______ dialog box.
a) Formatting Rules Manager
b) Manage Rules
c) Rules Manager
d) Conditional Formatting Rules Manager
09. Which option would you use to fill in weekdays skipping weekends in a date series?
a) Autofill Handle
b) Fill Series dialog, set type to 'Weekday'
c) Simple copy and paste
d) Flash Fill
10. Where would you typically find the option to enable macros in a workbook?
a) File > Options > Trust Center > Trust Center Settings
b) Review > Protect Workbook
c) Data > Connections
d) Insert > Add-ins
Answers:
Question: 01
Answer: a |
Question: 02
Answer: d |
Question: 03
Answer: a |
Question: 04
Answer: a, c, d |
Question: 05
Answer: b |
Question: 06
Answer: a, c |
Question: 07
Answer: a, b |
Question: 08
Answer: d |
Question: 09
Answer: b |
Question: 10
Answer: a |
Note: For any error in Microsoft Office Specialist - Excel Expert (Microsoft 365 Apps) (MO-211) certification exam sample questions, please update us by writing an email on feedback@edusum.com.
