Loading demo links...
Showing 1–5 of 5 questions
CORRECT TEXT
On the ‘’Prices’’ worksheet, apply the Title style to cell A1.
Answer is in the explanation below.
CORRECT TEXT
You are compiling class data to present to the enrollment director at the School of Fine Art.
On the ‘’Substitutes’’ worksheet beginning at cell A1, import the data from the Substitutes text file in the Documents folder. Use the first row of the data source as headers.
Answer is in the explanation below.
CORRECT TEXT
On the ‘’Summary’ worksheet, in cell B15, use a function to display the highest sales amount from the ‘’Total Sales’’ column.
Answer is in the explanation below.
CORRECT TEXT
On the ‘Comparison’ chart sheet, swap the data the axis.
Answer is in the explanation below.
CORRECT TEXT
You are revising a sales summary report for Northwind Traders.
On the ‘’Summary’’ worksheet, in cells F4:F11, use conditional formatting to apply the
Yellow Fill with Dark Yellow Text format to cells that contain values greater than
‘’$5,000,000.’’
Answer is in the explanation below.
This page holds a free practice test for the Microsoft Excel (Excel and Excel 2019) (MO-200) certification from Microsoft. The 5 questions are a free sample of the full Study4Pass practice set of 35 questions, so you can check your level before you commit to the real exam. The free sample is made up of 5 hands-on lab questions, each with a full explanation. Questions are spread across the areas that matter most on the real exam: The components of Microsoft 365 Enterprise, Such as Microsoft 365 Apps, Microsoft 365 Security & Compliance and And Microsoft 365 Devices & Management. Microsoft MO-200 is the Microsoft Office Specialist (MOS) Expert certification exam for Microsoft Word.
The Microsoft MO-200 exam is intended for individuals who are looking to gain expertise in Microsoft 365 and Microsoft 365 Security Administration. The Microsoft MO-200 exam requires a candidate to have experience in Microsoft 365 tenant management and Microsoft 365 security management.
Treat this sample as a diagnostic. Answer honestly, check the explanation after every question, and note which topics feel shaky. A short, focused review of those topics is worth more than re-reading everything — and the full set lets you drill them topic by topic.
A good way to use this page: take the whole sample in one sitting, then go back over every explanation with fresh eyes. Mark the topics that felt uncertain, not just the ones you got wrong — uncertain answers are unmarked risk on the real exam. One or two focused passes like this usually move a score more than days of passive reading.
Inside the full MO-200 practice set:
Answer a question, then check the result to see the correct answer and the explanation behind it. Work at your own pace — there is no timer and no signup. Stuck on a concept? This is an AI-Enabled practice test: use Ask AI on any question and get the underlying concept explained in plain words, so you learn the reasoning instead of memorizing answers. Ready for more? The full 35-question set adds a timed Exam Simulation mode, topic training for your weak areas, and a flagged-question review, so you can practise the way the real exam feels.
Yes — the 5 questions on this page are completely free, with no signup and no payment details needed.
35 questions. The 5 free questions above are a sample of that full set, in the same style and topic balance.
Yes — every question shows the correct answer with an explanation, and Ask AI can explain the concept behind a question in plain words if you want to go deeper.
No. This is a practice test: the questions are written to mirror the real MO-200 exam’s topics and difficulty, not copied from it.