Skip to main content
ITPrepCerts
Login
Exams Free Samples About Contact
Login Create an account

MO-211 Microsoft Excel Expert (Microsoft 365 Apps)

  • Microsoft
  • 5 free sample questions

About this exam

MO-211 is the Microsoft exam Microsoft Excel Expert (Microsoft 365 Apps). Paid practice material for this exam is not available yet, but you can try its free sample questions.

Exam code
MO-211
Vendor
Microsoft
Practice questions
Not available yet
Free sample questions
5
Question bank last updated
Not available yet

Try 2 sample questions

Taken from the free sample set for MO-211.

Question 1

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

  1. Option A:
    Ascending
  2. Option B:
    Custom
  3. Option C:
    Descending
  4. Option D:
    Random
Show answer and explanation

Correct answer: C

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.

Question 2

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

  1. Option A:
    Border
  2. Option B:
    Fill
  3. Option C:
    Alignment
  4. Option D:
    Font 
Show answer and explanation

Correct answer: B

 Fill is not available as a separate formatting option in the Format Cells dialog box in Excel. 
See all 5 free sample questions