Exam MO-211: Microsoft Excel Expert (Microsoft 365 Apps) Practice Test
MO-211 practice covers advanced Excel workbook and worksheet work, including formulas, formatting, display settings, and print preparation. The question bank samples decisions such as identifying external workbook links, writing a three-dimensional sheet reference, choosing functions for date and minimum-value calculations, and setting custom number formats. It also addresses worksheet comments or notes, gridline visibility, frozen panes, and report layout choices.
Exam overview
About the Exam MO-211: Microsoft Excel Expert (Microsoft 365 Apps) Exam
Expert-level spreadsheet work depends on selecting features that preserve calculation logic while making data easier to inspect and present. Practice the distinction between formulas that return dynamic results and values that are manually entered, and consider how formulas behave when they reference multiple worksheets or linked files. Custom number formats can display positive, negative, and zero values differently without changing the underlying numbers. Worksheet-level choices—such as hiding gridlines or freezing heading rows—affect navigation and screen presentation, while print settings, headers, and hidden formula rows affect the report readers receive. Selecting the right function or setting requires identifying the intended result, the range involved, and whether text or recalculation should affect the outcome.
Sample Practice Questions
Review a selection from this exam's published US Practice Tests practice bank.
A workbook contains formulas linked to external workbooks. Before sharing it, you want to identify the files those links refer to. Which feature should you inspect?
Show answer
Correct answer: BThe Edit Links feature, where available for the workbook's links, shows linked source workbooks and provides options for managing those external references.
You want to insert a footnote-style explanation for a value in a worksheet so readers can see it when they select the relevant cell. Which feature is appropriate?
Show answer
Correct answer: AA cell comment or note attaches explanatory text to a specific cell, which readers can view by selecting or hovering over it depending on the Excel version and settings. The other options do not provide cell-specific explanatory text.
You need to apply a custom number format that shows positive values with a plus sign, negative values with a minus sign, and zero as a dash. Which format code uses separate sections for these cases?
Show answer
Correct answer: ACustom number formats can use sections separated by semicolons for positive, negative, and zero values, in that order. The format +0;-0;- applies the requested display while leaving the underlying values numeric.
You want to remove a worksheet's gridlines from view without changing cell borders or affecting other worksheets. Which setting should you change?
Show answer
Correct answer: AThe Gridlines display setting controls whether worksheet gridlines are shown. It does not remove existing cell borders, and the setting applies to the current worksheet view rather than formatting every cell.
You have a workbook with several worksheets and want a formula on one sheet to calculate the total of cell F8 from three other sheets named North, South, and West. Which formula is correct?
Show answer
Correct answer: AA 3-D reference uses the first and last worksheet names separated by a colon, followed by the cell reference. SUM(North:West!F8) totals F8 across all worksheets between North and West, inclusive, in tab order.
A worksheet has formulas that should not be included in the printed report, but should remain available in the workbook. Which approach is appropriate?
Show answer
Correct answer: ARows or columns hidden on the worksheet are omitted from the printed output while their contents remain in the workbook. Converting formulas to values changes the workbook, and the Hidden format alone does not suppress cell contents in printouts.
You want a printed worksheet to include a small company logo at the top of every page without placing the image in worksheet cells. Where should you add it?
Show answer
Correct answer: AA header can contain a picture, such as a logo, and appears in the page header when the worksheet is printed. A worksheet background is primarily a screen display feature and does not print as a page header.
How to use this practice test
The free US Practice Tests practice bank contains 50 published questions; a session presents up to 20 random questions. Use the questions to check your Excel feature selection and formula reasoning, then review the results shown after the session to identify areas for targeted practice.
Preparation tips
- Write and check formulas that reference cells across multiple worksheets, including sheet names and range syntax.
- Test custom number-format sections for positive, negative, and zero values, and distinguish display formatting from changing stored data.
- Compare functions such as MIN and TODAY by their treatment of text, recalculation, and return values.
- Practice worksheet navigation and presentation settings, including freezing heading rows, hiding gridlines, and adding repeated print headers or footers.
- Inspect workbook links and distinguish hiding formulas from removing or altering their calculations before printing.