MO-200 Excel Associate practice questionsMicrosoft certification practice
← Interview & exam prep
Microsoft certification practice

MO-200 Excel Associate practice questions

12 exam-style questions for MO-200 — Microsoft Excel Associate, each with the correct answer and why. Then take a timed practice test that also draws on the related skill banks.

12 questionsBeginner 6 · Intermediate 6Answers + explanations
Take it as a timed test
Free PDF
All 389 questions & answers, in one file

DAX, Excel, Power BI, Fabric, certification practice and analyst interviews — every answer with the reason behind it. Print it, study it offline.

Instant download, plus the free Tuesday briefing. Unsubscribe in one click.

Skills measured

  • Manage worksheets and workbooks
  • Manage data cells and ranges
  • Use formulas and functions
  • Manage tables and charts
Official MO-200 exam page ↗

Study by skill area

Beginner 6 questions

1To keep the top row visible while scrolling a long sheet, you use…

  1. Split only
  2. Protect Sheet
  3. Hide Rows
  4. Group
  5. Freeze Panes
Show answerHide answer

E · Freeze Panes Freeze Panes keeps chosen rows/columns visible while scrolling.

2To fill Jan, Feb, Mar… quickly, you use…

  1. Data Validation
  2. A PivotTable
  3. Copy-paste each
  4. Auto Fill (the fill handle)
  5. A macro
Show answerHide answer

D · Auto Fill (the fill handle) Drag the fill handle to extend a recognized series.

3To turn a range into a structured Excel Table, you press…

  1. Ctrl+T
  2. Ctrl+F
  3. Ctrl+Z
  4. Ctrl+P
  5. Ctrl+S
Show answerHide answer

A · Ctrl+T Ctrl+T creates a Table from the selected range.

4When copying a formula down, which reference style stops A1 from shifting?

  1. A$1
  2. $A$1
  3. $A1
  4. A1
  5. A@1
Show answerHide answer

B · $A$1 $A$1 is absolute — neither row nor column shifts when copied.

5To visualize selected data, you go to Insert and add a…

  1. Chart
  2. Table style
  3. Name
  4. Macro
  5. Comment
Show answerHide answer

A · Chart Insert > Charts turns the selection into a chart.

6AutoSum quickly inserts which function for a contiguous range?

  1. AVERAGEIF
  2. COUNT
  3. IF
  4. VLOOKUP
  5. SUM
Show answerHide answer

E · SUM AutoSum inserts a SUM over the adjacent range by default.

Intermediate 6 questions

7To count how many cells meet one condition, you use…

  1. IF
  2. SUM
  3. CONCAT
  4. LEN
  5. COUNTIF
Show answerHide answer

E · COUNTIF COUNTIF counts cells that match a single criterion.

8To split full names in one column into two columns, you use…

  1. Freeze Panes
  2. Consolidate
  3. Remove Duplicates
  4. Text to Columns
  5. Sort
Show answerHide answer

D · Text to Columns Text to Columns separates delimited text into multiple columns.

9To delete repeated rows from a range, you use…

  1. Sort
  2. Subtotal
  3. Group
  4. Remove Duplicates
  5. Filter
Show answerHide answer

D · Remove Duplicates Remove Duplicates deletes duplicate rows based on chosen columns.

10IF(logical_test, a, b) returns…

  1. The sum of a and b
  2. Always b
  3. An error
  4. Always a
  5. a if the test is TRUE, otherwise b
Show answerHide answer

E · a if the test is TRUE, otherwise b IF returns the first value when the test is TRUE, else the second.

11To average a range while ignoring text and blank cells, you use…

  1. AVERAGE
  2. MEDIAN
  3. MODE
  4. COUNT
  5. SUM
Show answerHide answer

A · AVERAGE AVERAGE averages the numeric values, ignoring text/blanks.

12To arrange a table from A→Z by a column, you use…

  1. Freeze Panes
  2. Sort (A to Z)
  3. Filter
  4. Group
  5. Consolidate
Show answerHide answer

B · Sort (A to Z) Sort orders rows by the chosen column.

What changed lately? Latest Formulas & Functions news, releases & questions →

Coming soon $19 one-time · early-access price
Prep Pro: full mock exams
  • Full-length, timed mock exams in the real PL-300, DP-600 and MO-201 format
  • Score breakdown by skill, with a study plan for your weak spots
  • New questions every month, written against the current exam outline

No payment now. We'll email you once, when it opens.

More microsoft certification practice