Question 1

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

Options :

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 of the following chart types should you use to compare values across categories?

Options :

A : Scatter chart

B : Bubble chart

C : Bar chart

D : Line chart

Answer: C

Question 3

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

Options :

A : Scatter chart

B : Line chart

C : Stacked bar chart

D : Radar chart

Answer: D

Question 4

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

Options :

A : COUNT

B : COUNTIF

C : AVERAGEIF

D : SUMIF

Answer: A

Question 5

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

Options :

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

Free MO-211 Mock Exam – Practice Online Confidently