Free Practice Microsoft MO-211 Exam Questions 2025

Stay ahead with 100% Free Microsoft Excel Expert (Microsoft 365 Apps) MO-211 Dumps Practice Questions

Page: 1 / 69

Total 345 Questions | Updated On: Apr 22, 2025

Add To Cart

Question 1

What does the CONCATENATE function do in Excel?

A : Adds two or more cells

B : Joins two or more text strings into one

C : Returns the average of two or more cells

D : Multiplies two or more cells

Answer: B

Question 2

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 3

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 4

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 5

What is the Excel function that calculates the number of days between two dates?

A : DAYDIF()

B : DATEDELTA()

C : DATEDIF()

D : DATE_DIFF()

Answer: C

Page: 1 / 69

Total 345 Questions | Updated On: Apr 22, 2025

Add To Cart