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: Sep 24, 2026

Add To Cart

Question 1

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 2

Which of the following is NOT a valid way to filter data in a pivot table in Excel?

A : Using the Filter pane on the right-hand side of the screen

B : Using the Filter option in the context menu

C : Dragging a field into the Rows area

D : Typing the FILTER function into a cell and referencing the pivot table rang

Answer: D

Question 3

What is the formula used in Excel to calculate the percentage change between two numbers?

A : #NAME?

B : #NAME?

Answer: B

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

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

Page: 1 / 69

Total 345 Questions | Updated On: Sep 24, 2026

Add To Cart