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: Oct 27, 2025

Add To Cart

Question 1

Which macro security setting in Excel enables macros to run without any restrictions?

A : Disable all macro settings except digitally signed macros

B : Disable all macros with notification

C : Disable all macros except digitally signed macros

D : Enable all macros

Answer: D

Question 2

Which chart type is best for comparing multiple data series?

A : Bar Chart

B : Scatter Chart

C : Pie Chart

D : Line Chart

Answer: A

Question 3

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

Question 4

Which of the following is NOT a valid way to sort a table in Excel?

A : Right-clicking on a cell and selecting Sort

B : Using the Sort & Filter button on the Home tab

C : Typing the SORT function into a cell and referencing the table range

D : Selecting the Sort button on the Data tab

Answer: C

Question 5

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

Page: 1 / 69

Total 345 Questions | Updated On: Oct 27, 2025

Add To Cart