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: Jun 15, 2026

Add To Cart

Question 1

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 2

What feature in Excel allows you to format a chart element based on predefined criteria?

A : Chart layouts

B : Chart templates

C : Chart titles

D : Chart styles

Answer: D

Question 3

How many characters can a cell hold in Excel?

A : 32767

B : 256

C : 255

D : 1024

Answer: A

Question 4

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 5

What is the purpose of the CountA function in Excel?

A : To count the number of cells in a range that contain blank values.

B : To count the number of cells in a range that contain error values.

C : To count the number of cells in a range that are not empty.

D : To count the number of cells in a range that contain numerical values.

Answer: C

Page: 1 / 69

Total 345 Questions | Updated On: Jun 15, 2026

Add To Cart