Exam MO-201: Microsoft Excel Expert (Office 2019) Practice Test
MO-201 practice covers advanced spreadsheet work in Excel for Office 2019, including formula construction, worksheet controls, and presentation of workbook data. The question bank samples practical tasks such as protecting formulas while leaving input cells editable, creating conditional results, managing references across worksheets, and preparing workbooks for printing. These skills support accurate, reusable spreadsheets for reporting and analysis.
Exam overview
About the Exam MO-201: Microsoft Excel Expert (Office 2019) Exam
Strong Excel expertise involves choosing formulas and references that behave correctly when copied, then applying formats that communicate values without changing the underlying data. Tasks sampled in this practice bank include using text functions, writing conditional formulas, and distinguishing absolute from relative references. Worksheet management also matters: users may need to protect calculated cells, validate entries with prompts and limits, duplicate sheets, or organize records for printed output. For charts, selecting a source that can accommodate an expanding table helps keep visual summaries aligned with changing data. These decisions are useful when building workbooks that other people must edit, review, or print reliably. The examples provide practice with specific Excel operations rather than a stated list of official exam domains.
Sample Practice Questions
Review a selection from this exam's published US Practice Tests practice bank.
A worksheet contains formulas that you do not want users to overwrite, but users should still be able to edit input cells. What should you do before protecting the worksheet?
Show answer
Correct answer: AExcel cells are locked by default, but that setting takes effect only when the sheet is protected. Unlock the cells users may edit first, then protect the worksheet so locked formula cells remain protected.
A cell contains the text value "North Region". Which function returns the number of characters in that cell, including the space?
Show answer
Correct answer: BLEN returns the number of characters in a text string, including spaces. COUNT counts numeric cells, VALUE attempts to convert text to a number, and EXACT compares two text strings.
A worksheet has a chart based on a table, and new rows are added to that table. Which chart source choice is most likely to let the chart include the new table rows automatically?
Show answer
Correct answer: ACharts based on an Excel table can expand as table rows are added, allowing the chart to include the new data. A fixed range that excludes added rows will not automatically cover them.
You want to restrict a cell to whole numbers from 1 through 12 and show an input prompt when the cell is selected. Which feature supports both requirements?
Show answer
Correct answer: AData Validation can limit entries to whole numbers within specified bounds and can display an input message when a user selects the cell.
A worksheet contains formulas that reference cells on another worksheet in the same workbook. Which notation identifies the worksheet in a direct cell reference?
Show answer
Correct answer: AA direct reference to another worksheet uses the sheet name followed by an exclamation mark and the cell reference, such as =Summary!B4.
A cell should show the word "Complete" when A2 contains 100, and otherwise remain blank. Which formula meets this requirement?
Show answer
Correct answer: AIF tests whether A2 equals 100. If true, it returns Complete; if false, the empty text string causes the cell to appear blank.
A workbook contains repeated records for many departments. You want each department's records to appear on a separate printed page. Which worksheet setting is designed to control this?
Show answer
Correct answer: BPage breaks determine where printed pages begin and end. Inserting or adjusting page breaks can start each department's records on a new page.
How to use this practice test
Access is free. Each session draws up to 20 random questions from the 50-question MO-201 practice bank and displays results afterward. Use the questions to check how well you can select Excel features for formula behavior, worksheet protection, data validation, chart sources, and print layout; revisit any missed operation in Excel.
Preparation tips
- Practice unlocking input cells and protecting a worksheet so formulas remain protected while designated entries can still be changed.
- Write conditional formulas and test them with values that meet and do not meet the condition; check whether the result should be blank or display text.
- Copy formulas across rows and columns to verify when relative, absolute, and mixed cell references should adjust.
- Use data validation to set whole-number limits and an input prompt, then test the permitted and rejected entries.
- Build a chart from an Excel table, add records, and inspect whether the chart source expands; also test worksheet print settings for page breaks and date display formats.