MO-211 Practice Online

Question 1

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

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 4

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 5

What is the formula to calculate the sum of cells that meet multiple criteria in Microsoft Excel?

A : SUMIF() and SUMIFS()

B : SUMIF()

C : AVERAGEIF() and AVERAGEIFS()

D : SUMIFS()

Answer: D

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