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 11, 2025

Add To Cart

Question 1

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

Question 2

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 3

What chart type would you use to compare values across categories?

A : Area chart

B : Column chart

C : Histogram

D : Scatter chart

Answer: B

Question 4

What chart type would you use to show the correlation between two variables?

A : Scatter chart

B : Pie chart

C : Bubble chart

D : Line chart

Answer: A

Question 5

How many characters can a cell hold in Excel?

A : 32767

B : 256

C : 255

D : 1024

Answer: A

Page: 1 / 69

Total 345 Questions | Updated On: Mar 11, 2025

Add To Cart