Build advanced Excel reasoning with 120 original practice questions from Cloudpuz Academy. Two different 60-question sets cover the MO-211 Excel Expert objectives for Microsoft 365 Apps. Every question includes four choices, one best answer, an explanation for each choice and a reference for further study. These are original learning scenarios, not recalled certification questions.

This course provides multiple-choice concept practice. The official MO-211 assessment is performance-based and requires completing tasks in Excel projects. These questions complement hands-on preparation; they do not reproduce the official examination interface. Each course test allows 90 minutes for careful analysis. The 70 percent setting is a study target and does not represent the official passing standard.

The bank covers four areas: workbook options and settings, managing and formatting data, advanced formulas and macros, and advanced charts and tables. The complete allocation is 16, 38, 34 and 32 questions respectively. Each test includes all four areas. Scenarios assume Excel for Microsoft 365 desktop on Windows unless stated otherwise. Formula examples use English function names and comma argument separators.

Workbook decisions include macro preservation and trust, workbook structure and worksheet protection, controlled input cells, version history, external workbook links, calculation mode and precision. Distinguish editing safeguards from confidentiality protection and select changes that directly address the stated requirement.

Data questions address Flash Fill, linear and growth series, random arrays, custom number formats, validation, outlines, subtotals, duplicate criteria and conditional formatting. Follow the explanations to separate changes to stored values from changes to presentation, and identify the correct scope of an operation before applying it.

Formula and macro questions explore conditional aggregation, nested logic, LET, exact lookups, INDEX and MATCH, working dates, financial periods, dynamic arrays, Goal Seek, scenarios and consolidation. Auditing scenarios cover precedents, error checking, the Watch Window and formula evaluation. Macro questions cover recording choices, valid names, storage and controlled editing.

Chart and analysis questions include secondary axes, histograms, box-and-whisker charts, waterfalls, sunbursts and funnels. PivotTable and PivotChart cases address source quality, refresh, grouping, slicer connections, calculated fields, value display and hierarchy exploration. Read all option explanations to understand the assumptions behind the correct choice.

Use the first test to locate gaps, then reproduce unfamiliar operations in your own Excel installation. Attempt the second set after reviewing the linked documentation. This course includes practice tests and written explanations. It does not include video lessons, downloadable workbook exercises, a hosted Excel environment, a Microsoft 365 license or an exam voucher.

Questions received author documentation review, a complete editorial reread and duplicate screening against available local question banks. Selected formula outputs were checked with a calculation engine and documentation. This is not a complete execution of every workflow in Microsoft Excel or an independent expert endorsement. Cloudpuz Academy is independent and is not affiliated with Microsoft or Certiport. Check current official exam requirements; practice scores do not award or guarantee certification.