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: Jul 28, 2025

Add To Cart

Question 1

Which Excel function can be used to remove spaces from the beginning and end of a text string?

A : LEFT

B : RIGHT

C : CLEAN

D : TRIM

Answer: D

Question 2

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 3

How many characters can a cell hold in Excel?

A : 32767

B : 256

C : 255

D : 1024

Answer: A

Question 4

Which of the following formatting options is not available in the Format Cells dialog box in Excel?

A : Border

B : Alignment

C : Fill

D : Font

Answer: C

Question 5

How can you easily remove blank rows in Excel?

A : Select the row, click the Home tab, choose Delete in the Cells group, and then select Delete Sheet Rows

B : Highlight the row, click the Home tab, choose Delete in the Cells group, and then select Delete Dialog Box

C : Highlight the columns, click on Conditional Formatting, choose New Rule, and then click Use a formula

D : Highlight the row, right-click, and select delete

Answer: A

Page: 1 / 69

Total 345 Questions | Updated On: Jul 28, 2025

Add To Cart