GMetrix is the industry-standard practice platform for Microsoft Office Specialist (MOS) certification exams. Instead of multiple-choice questions, GMetrix uses a task-based format where you perform actual operations inside Microsoft Office applications — formatting a Word document, writing an Excel formula, or building a PowerPoint animation. Our free printable PDF translates those skill areas into written practice questions so you can study anywhere, even without a computer in front of you.
Download the PDF below, work through all the questions, and use the included answer key to identify skill gaps in Word, Excel, PowerPoint, Access, or Outlook before you sit for your official MOS certification exam.
Each GMetrix module maps directly to a Microsoft Office Specialist certification exam. Here is what you need to master across the core applications.
Word tasks cover document formatting, applying and modifying styles, inserting and formatting tables, performing mail merges, managing references and citations, and using track changes for collaborative editing. Expert-level tasks include building and modifying macros and advanced field codes.
Excel is the most heavily tested application. You need to know core functions — SUM, AVERAGE, IF, VLOOKUP, and INDEX-MATCH — plus how to build and format charts, create and analyze PivotTables, apply data validation rules, and use conditional formatting to highlight trends. Expert tasks add named ranges, what-if analysis, and complex nested formulas.
PowerPoint tasks include designing and formatting slides, applying transitions and custom animations, inserting and editing SmartArt, working with slide masters, and using presenter tools like notes and rehearse timings. You may also be tested on embedding video, audio, and hyperlinks.
Access tasks cover creating and modifying database tables and relationships, writing select and action queries, building data entry forms, and generating reports with grouping and calculated fields. Understanding primary keys and referential integrity is essential.
Outlook tasks involve managing email with rules and folders, scheduling calendar appointments and meetings, assigning tasks, and configuring contact groups. GMetrix Outlook exams also test Quick Steps, signatures, and out-of-office auto-replies.
Looking for more interactive prep? Our full GMetrix practice test delivers timed, scored questions across all MOS application areas with detailed explanations for every answer. Pair the online tests with the printable PDF to reinforce both conceptual understanding and hands-on task skills before you take the official Microsoft Office Specialist exam through GMetrix.