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: Feb 29, 2024

Add To Cart

Question 1

What is the formula used in Excel to calculate the percentage change between two numbers?

A : #NAME?

B : #NAME?

Answer: B

Question 2

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 3

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 4

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 5

Which of the following features is used to transpose columns and rows of data?

A : Sort

B : Charting

C : PivotTable

D : Transpose

Answer: D

Page: 1 / 69

Total 345 Questions | Updated On: Feb 29, 2024

Add To Cart