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: Jan 08, 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

Which of the following chart types should you use to compare values across categories?

A : Scatter chart

B : Bubble chart

C : Bar chart

D : Line chart

Answer: C

Question 3

Which chart type is used to represent data that is consecutively measured over time?

A : Column chart

B : Bar chart

C : Pie chart

D : Line chart

Answer: D

Question 4

Which of the following formats displays negative numbers in parentheses in Excel?

A : Percentage

B : Accounting

C : Currency

D : None of the above

Answer: B

Question 5

How can you easily remove blank rows in Excel?

A : Select the row, click the Home tab, choose Delete in the Cells group, and then select Delete Sheet Rows

B : Highlight the row, click the Home tab, choose Delete in the Cells group, and then select Delete Dialog Box

C : Highlight the columns, click on Conditional Formatting, choose New Rule, and then click Use a formula

D : Highlight the row, right-click, and select delete

Answer: A

Page: 1 / 69

Total 345 Questions | Updated On: Jan 08, 2025

Add To Cart