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: May 22, 2026

Add To Cart

Question 1

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

A : #NAME?

B : #NAME?

Answer: B

Question 2

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 3

What is the keyboard shortcut to automatically fill a series of values into cells in Microsoft Excel?

A : Ctrl + D

B : Ctrl + Shift + D

C : Ctrl + R

D : Ctrl + Shift + R

Answer: A

Question 4

What is the benefit of using tables in Excel?

A : They allow you to add animations and transitions to data.

B : They allow you to sort, filter, and analyze data easily.

C : They allow you to convert data into charts easily.

D : They allow you to create complex formulas and macros.

Answer: B

Question 5

What is the purpose of the CountA function in Excel?

A : To count the number of cells in a range that contain blank values.

B : To count the number of cells in a range that contain error values.

C : To count the number of cells in a range that are not empty.

D : To count the number of cells in a range that contain numerical values.

Answer: C

Page: 1 / 69

Total 345 Questions | Updated On: May 22, 2026

Add To Cart