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: Jun 04, 2025

Add To Cart

Question 1

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 2

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

Question 3

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 4

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

Question 5

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

A : Area chart

B : Column chart

C : Histogram

D : Scatter chart

Answer: B

Page: 1 / 69

Total 345 Questions | Updated On: Jun 04, 2025

Add To Cart