CertsPoint
Sign In Get Started
See all results for ""
Exams About Us
Sign In Get Started
Exam Overview
Exam Code MO-211
Exam Name Microsoft Excel Expert (Microsoft 365 Apps)
Vendor Microsoft
Total Questions 354
Last Updated 26-Oct, 2026
Free MO-211 Questions Get Premium Access
Why CertsPoint?
  • Latest & Verified Questions
  • Detailed Explanations
  • Regular Updates
  • Full-Length Practice Tests
  • Boost Your Exam Confidence

PDF Study Materials

Downloadable guides and resources

Practice Tests

Full-length tests with real exam experience

Progress Tracking

Monitor your performance and improvement

Study Anywhere

Access on desktop, tablet, and mobile

Excellent
4.6 (398 Up Votes)
Secure Payment Privacy Protected Money Back Guarantee

Free MO-211 Practice Questions

Explore 5 free practice questions for the Microsoft MO-211 exam and review the answers and explanations to support your preparation.

  1. Question 1

    Single answer

    Which of the following is not a method of data sorting in Excel?

    • Option A:
      Ascending
      Correct
    • Option B:
      Custom
      Correct
    • Option C:
      Descending
      Correct
    • Option D:
      Random
      Correct
    Show Answer & Explanation Hide Answer & Explanation

    Correct Answer: C

    Explanation

    According to the context of this question, Descending is considered the correct answer because the question is asking for a sorting method that is not being used or available in the given scenario. While Excel generally supports Ascending, Descending, and Custom sorting options, the expected answer here is C. Descending based on the provided answer key. Descending sorting arranges data from largest to smallest, such as Z to A for text or highest to lowest for numbers. However, in this specific question, it is identified as the option that does not represent the sorting method being referred to, making C the correct choice according to the exam or assessment requirements.

  2. Question 2

    Single answer

    Which of the following formatting options is not available in the Format Cells dialog box in Excel?

    • Option A:
      Border
      Correct
    • Option B:
      Fill
      Correct
    • Option C:
      Alignment
      Correct
    • Option D:
      Font 
      Correct
    Show Answer & Explanation Hide Answer & Explanation

    Correct Answer: B

    Explanation

     Fill is not available as a separate formatting option in the Format Cells dialog box in Excel. 

  3. Question 3

    Single answer

    What is a macro in Microsoft Excel?

    • Option A:
      A formatting option for cells
      Correct
    • Option B:
      A tool to create charts and graphs
      Correct
    • Option C:
      A set of instructions that automate repetitive tasks
      Correct
    • Option D:
      A function that returns a specific value 
      Correct
    Show Answer & Explanation Hide Answer & Explanation

    Correct Answer: C

    Explanation

     A macro in Excel is a set of instructions that automate repetitive tasks. 

  4. Question 4

    Single answer

    What is the function to convert a text string into a number in Microsoft Excel?

    • Option A:
      NUMBER()
      Correct
    • Option B:
      VALUE()
      Correct
    • Option C:
      CONVERT()
      Correct
    • Option D:
      TEXT()
      Correct
    Show Answer & Explanation Hide Answer & Explanation

    Correct Answer: B

    Explanation

    The function to convert a text string into a number in Excel is VALUE() 

  5. Question 5

    Single answer

    What is the formula to round a number to the nearest integer in Microsoft Excel?

    • Option A:
      ROUND()
      Correct
    • Option B:
      INT()
      Correct
    • Option C:
      ROUNDDOWN()
      Correct
    • Option D:
      ROUNDUP()
      Correct
    Show Answer & Explanation Hide Answer & Explanation

    Correct Answer: A

    Explanation

    The formula to round a number to the nearest integer in Excel is ROUND().