MOS Excel Expert (Office 2019) exam-day guide
MOS Excel Expert (Office 2019) · Prepare for the day ahead.
Your checklist
Government-issued photo ID
Bring the same ID name that matches your exam registration exactly. If you test remotely, the proctor will check it on camera. Confirm with the provider which ID types are accepted for your testing channel (test center vs. online proctored).
Exam appointment confirmation and login details
Save the confirmation email or booking reference and know the exact start time and time zone. For online proctoring, have your login credentials and any system-check link ready before the session.
Working copy of Excel 2019 (desktop)
The exam targets the desktop Excel 2019 application, not Excel for the web. Practise in the same version you will be tested on so ribbon locations, dialog boxes, and function behavior match. Confirm with the provider which application build your exam session uses.
A quiet, well-lit room and stable internet (if testing online)
Remote proctoring typically requires a private room, a clear desk, working webcam and microphone, and a wired or stable connection. Run any required system test at least a day ahead. Exact room and equipment rules must be confirmed with the provider.
Practice files for the objective domains
Bring or review your own practice workbooks covering named ranges, tables, PivotTables, Power Query, macros, and data validation. Do not rely on any single question bank; build small files that exercise each skill end to end.
A one-page command map
Write a short reference of where key features live: Data > Get & Transform, Insert > PivotTable/PivotChart, Formulas > Name Manager, Developer > Macros/Visual Basic, and the Review > Protect options. Keep it as study material, not something to bring into the exam unless the provider explicitly allows notes.
Keyboard shortcut sheet memorized
Prioritize F4 (absolute reference toggle), Ctrl+Shift+L (filter), Alt+= (AutoSum), F2 (edit cell), Ctrl+1 (Format Cells), and Alt then key sequences for ribbon tabs. Shortcuts save minutes across a timed practical exam.
Backup plan for technical failure
Know the provider's procedure if Excel crashes or the session drops, and note any support phone number or chat link. Whether lost time is restored is provider-specific, so confirm with the provider in advance.
Water and a short break plan
Practical exams can run long. Check whether breaks are permitted and whether they stop the clock. Do not assume you can leave the room during a proctored session; confirm with the provider.
Time budget written down
Note the total exam duration and the number of tasks or projects. Decide a rough minutes-per-task target and a checkpoint time by which you should be roughly halfway done.
Plan the day
Run a full timed practice session in Excel 2019 using your own files. Simulate the real format: open a workbook, follow task instructions, save, and move on without lingering. Record which objectives cost you the most time.
Re-drill weak domains hands-on rather than by reading. For example, rebuild a PivotTable from raw data, then add a calculated field and a slicer; import a CSV with Power Query and clean a column; record a macro and edit it in the VBA editor.
Review the high-frequency mechanics: absolute vs. relative references, structured table references, VLOOKUP vs. INDEX/MATCH vs. XLOOKUP availability, IFERROR, SUMIFS/COUNTIFS, and data validation with custom formulas. Confirm which functions exist in your Excel 2019 build.
Practise the ribbon paths you use least: conditional formatting rules manager, Remove Duplicates, Text to Columns, Consolidate, Subtotal, Goal Seek, Scenario Manager, and the Watch Window.
Do one final light practice pass, then stop heavy study. Confirm your appointment time, time zone, ID, and (if online) room setup and system test. Charge devices and clear your desk.
Re-read your one-page command map and shortcut sheet. Get a full night's sleep; fatigue hurts accuracy more than lack of one more practice file.
Eat, hydrate, and arrive or log in early. For a test center, allow extra travel time; for online proctoring, start the check-in process before the scheduled time so setup issues do not eat into your exam clock.
Read each task fully before touching the workbook, and note exactly what is being asked (which sheet, which range, which output). Do the straightforward tasks first if the format lets you navigate freely, then return to harder ones.
Save frequently and keep an eye on the clock against your checkpoint. If a task stalls, make the best reasonable attempt, move on, and come back only if time remains.
Before finishing, verify that required outputs exist where specified (correct sheet, correct cell range, formulas not hard-coded values, macros saved in a macro-enabled format). Submit only after a final check.
Rules to check
Bring ID that matches your registration name exactly; the proctor or test center will verify identity before you start. Accepted ID types vary by provider and channel, so confirm with the provider.
Do not bring notes, phones, smart watches, or other materials into the testing area unless the provider explicitly permits them. Assume a clear desk and no external help.
Follow all proctor instructions. For online sessions, keep your face and workspace visible, do not leave the camera view, and do not talk to anyone. Violations can void your result; exact rules must be confirmed with the provider.
Ask about breaks before the exam starts. Whether breaks are allowed, whether they pause the clock, and whether you may leave the room are provider-specific, so confirm with the provider rather than assuming.
Understand the scoring model before test day: practical exams are typically scored on completing specified tasks correctly, and results are usually reported as pass/fail against a cut score. The exact scale and passing threshold are set by the provider; confirm with the provider.
If a technical problem occurs, stop and contact the proctor or support immediately rather than continuing silently. Whether the attempt is rescheduled or time is restored is provider-specific.
Do not attempt to copy, screenshot, or share exam content. Exam materials are confidential, and sharing them can result in score cancellation or other sanctions.
If you need to reschedule, follow the provider's cancellation and rescheduling window and fees. Do not assume a free change; confirm with the provider.