Free Microsoft MO-211 Exam Questions

Become Microsoft Certified with updated MO-211 exam questions and correct answers

Page: 1 / 69

Total 345 Questions | Updated On: Mar 21, 2026

Add To Cart

Question 1

Which of the following is NOT a valid way to filter data in a pivot table in Excel?

A : Using the Filter pane on the right-hand side of the screen

B : Using the Filter option in the context menu

C : Dragging a field into the Rows area

D : Typing the FILTER function into a cell and referencing the pivot table rang

Answer: D

Question 2

What is the keyboard shortcut to insert a new worksheet in an Excel workbook?

A : Ctrl + N

B : Shift + F11

C : Ctrl + W

D : Ctrl + Shift + N

Answer: D

Question 3

Which Excel function can be used to remove spaces from the beginning and end of a text string?

A : LEFT

B : RIGHT

C : CLEAN

D : TRIM

Answer: D

Question 4

Which of the following is not a number format in Excel?

A : Duration

B : Long date

C : Scientific

D : Short date

Answer: A

Question 5

What chart type would you use to show how individual parts contribute to the whole?

A : Line chart

B : Radar chart

C : Bubble chart

D : Pie chart

Answer: D

Page: 1 / 69

Total 345 Questions | Updated On: Mar 21, 2026

Add To Cart