Microsoft MO-211 Exam Real Questions

Prepare and pass your Microsoft Excel Expert (Microsoft 365 Apps) with free MO-211 exam questions.

Page: 1 / 69

Total 345 Questions | Updated On: Sep 27, 2024

Add To Cart

Question 1

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 2

Which chart type is most suitable for showing the relationships among different sets of values in a single chart?

A : Scatter chart

B : Line chart

C : Stacked bar chart

D : Radar chart

Answer: D

Question 3

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 4

What chart type would you use to show how individual parts contribute to the whole?

A : Line chart

B : Radar chart

C : Bubble chart

D : Pie chart

Answer: D

Question 5

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

Page: 1 / 69

Total 345 Questions | Updated On: Sep 27, 2024

Add To Cart