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: Jun 06, 2025

Add To Cart

Question 1

Which of the following is NOT a valid way to filter data in a pivot table in Excel?

A : Using the Filter pane on the right-hand side of the screen

B : Using the Filter option in the context menu

C : Dragging a field into the Rows area

D : Typing the FILTER function into a cell and referencing the pivot table rang

Answer: D

Question 2

Which built-in function is used to count the number of cells in a range that contain numbers?

A : COUNT

B : COUNTIF

C : AVERAGEIF

D : SUMIF

Answer: A

Question 3

What feature in Excel allows you to format a chart element based on predefined criteria?

A : Chart layouts

B : Chart templates

C : Chart titles

D : Chart styles

Answer: D

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

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

Page: 1 / 69

Total 345 Questions | Updated On: Jun 06, 2025

Add To Cart