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 27, 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 features is used to transpose columns and rows of data?

A : Sort

B : Charting

C : PivotTable

D : Transpose

Answer: D

Question 3

What is the keyboard shortcut to insert a new worksheet in an Excel workbook?

A : Ctrl + N

B : Shift + F11

C : Ctrl + W

D : Ctrl + Shift + N

Answer: D

Question 4

Which of the following data types is not supported in a VBA macro?

A : Boolean

B : Complex

C : Text

D : Date

Answer: B

Question 5

Which of the following is not a valid way to sort data in Excel?

A : By cell color

B : By fill color

C : By value

D : By font color

Answer: A

Page: 1 / 69

Total 345 Questions | Updated On: Mar 27, 2025

Add To Cart