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 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 2

What is the keyboard shortcut to display the Go To dialog box in Excel?

A : Ctrl + G

B : Ctrl + F

C : Ctrl + K

D : Ctrl + H

Answer: A

Question 3

Which of the following functions in Excel is used to concatenate two or more text strings into a single string?

A : RIGHT

B : LEFT

C : MID

D : CONCATENATE

Answer: D

Question 4

Which of the following Excel functions can be used to extract data from a table based on certain criteria?

A : INDEX-MATCH

B : HLOOKUP

C : SUMIF

D : VLOOKUP

Answer: A

Question 5

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

Page: 1 / 69

Total 345 Questions | Updated On: Sep 24, 2026

Add To Cart