Free Practice Microsoft MO-211 Exam Questions 2025

Stay ahead with 100% Free Microsoft Excel Expert (Microsoft 365 Apps) MO-211 Dumps Practice Questions

Page: 1 / 69

Total 345 Questions | Updated On: Mar 26, 2025

Add To Cart

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

Which of the following is NOT a valid way to sort a table in Excel?

A : Right-clicking on a cell and selecting Sort

B : Using the Sort & Filter button on the Home tab

C : Typing the SORT function into a cell and referencing the table range

D : Selecting the Sort button on the Data tab

Answer: C

Question 3

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

Question 4

What does the CONCATENATE function do in Excel?

A : Adds two or more cells

B : Joins two or more text strings into one

C : Returns the average of two or more cells

D : Multiplies two or more cells

Answer: B

Question 5

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

Page: 1 / 69

Total 345 Questions | Updated On: Mar 26, 2025

Add To Cart