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: Feb 18, 2025

Add To Cart

Question 1

Which of the following is used to split delimited text into columns?

A : VLOOKUP function

B : Filtering options

C : CONCATENATE function

D : Text to Columns feature

Answer: D

Question 2

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

What is the shortcut key combination to insert a new worksheet in your workbook?

A : Ctrl+W

B : Ctrl+Shift+N

C : Ctrl+Shift+W

D : Ctrl+Alt+W

Answer: B

Question 5

How many characters can a cell hold in Excel?

A : 32767

B : 256

C : 255

D : 1024

Answer: A

Page: 1 / 69

Total 345 Questions | Updated On: Feb 18, 2025

Add To Cart