← 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
Skills measured
- Manage worksheets and workbooks
- Manage data cells and ranges
- Use formulas and functions
- Manage tables and charts
Official MO-200 exam page ↗
Beginner 6 questions
1To keep the top row visible while scrolling a long sheet, you use…
- Split only
- Protect Sheet
- Hide Rows
- Group
- 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…
- Data Validation
- A PivotTable
- Copy-paste each
- Auto Fill (the fill handle)
- 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…
- Ctrl+T
- Ctrl+F
- Ctrl+Z
- Ctrl+P
- 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?
- A$1
- $A$1
- $A1
- A1
- 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…
- Chart
- Table style
- Name
- Macro
- Comment
Show answerHide answer
A · Chart Insert > Charts turns the selection into a chart.
6AutoSum quickly inserts which function for a contiguous range?
- AVERAGEIF
- COUNT
- IF
- VLOOKUP
- 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…
- IF
- SUM
- CONCAT
- LEN
- 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…
- Freeze Panes
- Consolidate
- Remove Duplicates
- Text to Columns
- 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…
- Sort
- Subtotal
- Group
- Remove Duplicates
- Filter
Show answerHide answer
D · Remove Duplicates Remove Duplicates deletes duplicate rows based on chosen columns.
10IF(logical_test, a, b) returns…
- The sum of a and b
- Always b
- An error
- Always a
- 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…
- AVERAGE
- MEDIAN
- MODE
- COUNT
- 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…
- Freeze Panes
- Sort (A to Z)
- Filter
- Group
- 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 →
More microsoft certification practice