MO-211 Practice Online

Question 1

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

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

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 4

How many characters can a cell hold in Excel?

A : 32767

B : 256

C : 255

D : 1024

Answer: A

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

Name:	Microsoft Excel Expert (Microsoft 365 Apps)
Exam Code:	MO-211
Certification:	Microsoft Office Specialist
Vendor:	Microsoft
Total Questions:	345
Last Updated:	Oct 25, 2026