Free Microsoft MO-211 Exam Dumps Questions & Answers

What is the best practice when creating macros to automate repetitive tasks?

• A.  Always use absolute references in recorded macros.
• B.  Record in one go without pausing.
• C.  Share macros by default with all users.
• D.  Modify recorded macros to optimize efficiency.

Which function is most suitable for calculating the number of periods for an investment to reach a specific value?

• A.  PV()
• B.  NPER()
• C.  RATE()
• D.  PMT()

When might you need to enable macros in a workbook that you received via email?

• A.  If the workbook contains interactive content
• B.  Only if the email is from a trusted source
• C.  Never, for security reasons
• D.  Always, to ensure full functionality

To format only cells that contain numbers within a specified range, use the _____ feature under Conditional Formatting.

• A.  Cell Value Rules
• B.  Number Rules
• C.  Range Rules
• D.  Highlight Cell Rules

How can you modify a PivotChart to better present data trends?

• A.  Change the chart style
• B.  Apply a complex formula
• C.  Insert a slicer
• D.  Use a secondary axis