Microsoft Excel Practice Test PDF (Free Printable 2026)

The Microsoft Office Specialist Excel certification is one of the most sought-after productivity credentials in the workforce, recognized by employers in industries from finance and accounting to healthcare administration and project management. Whether you are preparing for your first MOS exam or brushing up on a newer version of Excel, having a printable set of practice questions lets you review the content domains on your own terms — at a desk, on a commute, or anywhere away from a computer.

This page provides a free downloadable Excel practice test PDF with questions aligned to the MOS Excel certification content outline. Download it, print it, and use it alongside hands-on practice in Excel for the most effective preparation.

Excel Formulas and Functions

Formulas and functions make up the largest single domain on the MOS Excel certification exam. The exam tests your ability to construct formulas using the correct syntax, reference cells using absolute and relative references, and apply functions from multiple categories including logical, lookup, text, date and time, financial, and statistical.

Logical Functions

IF, AND, OR, NOT, IFS, and SWITCH are the core logical functions tested. Nested IF statements are a common exam task — you need to know how to build multi-level logical tests and understand how Excel evaluates them. The IFS function simplifies complex nested IFs by allowing multiple condition-result pairs without nesting, and the exam may present scenarios where IFS is the more appropriate choice.

Lookup and Reference Functions

VLOOKUP remains on the exam for all Excel versions currently tested (Excel 2019, 2021, and 365). XLOOKUP, which replaces VLOOKUP and HLOOKUP with a more flexible syntax, is tested on Excel 2021 and 365 exams. You need to understand the arguments of both functions, know when to use exact vs. approximate match, and understand the difference between VLOOKUP's column index number approach and XLOOKUP's return array approach. INDEX and MATCH are also tested as an alternative lookup method, particularly for scenarios where you need to look up values to the left or perform two-dimensional lookups.

Text and Date Functions

Text functions tested include LEFT, RIGHT, MID, LEN, FIND, SEARCH, CONCATENATE (and the ampersand operator), TEXTJOIN, UPPER, LOWER, PROPER, TRIM, and TEXT. Date functions include TODAY, NOW, DATE, DATEDIF, EDATE, EOMONTH, NETWORKDAYS, and YEAR/MONTH/DAY. The exam frequently presents tasks that require combining text and date functions — for example, extracting the month number from a date column and using it in a formula.

Data Analysis and PivotTables

PivotTables are one of Excel's most powerful tools for summarizing and analyzing large datasets, and they receive significant coverage on the MOS exam. You are expected to create PivotTables from table or range data, add and arrange fields in the Rows, Columns, Values, and Filters areas, change the summary function for value fields, apply filters, and format the PivotTable.

PivotTable Configuration

Beyond basic creation, the exam tests tasks like grouping date fields by month, quarter, or year; adding calculated fields; changing the PivotTable layout between compact, outline, and tabular form; and refreshing the PivotTable when the source data changes. Slicers — visual filter controls that can be connected to one or more PivotTables — are also tested, as is inserting PivotCharts linked to PivotTable data.

Sorting, Filtering, and Conditional Formatting

The data analysis domain also covers sorting by multiple columns, applying AutoFilter to a range, using advanced filter options, and applying conditional formatting rules. Conditional formatting tasks on the exam include applying data bars, color scales, icon sets, and custom rule-based formatting using formulas. Being able to manage conditional formatting rules — editing the rule formula, changing the format, adjusting the applies-to range, and setting rule priority — is directly tested.

Charts and Visualization

Creating, formatting, and modifying charts is a core exam domain. You are expected to insert charts from a data selection, change chart types, add and format chart elements (title, axis labels, legend, data labels, trendlines, error bars), and switch the row/column orientation of the data series.

Chart Types and Selection

The exam covers column charts, bar charts, line charts, pie and doughnut charts, area charts, scatter plots, and combination charts that use two chart types on the same axes. Knowing which chart type is appropriate for a given data scenario — for example, using a scatter plot for correlation data or a combination chart when you need to plot two data series with different scales — is part of what the exam tests. Sparklines, the small in-cell charts that summarize data trends in a single cell, are also included.

Data Validation and Formatting

The MOS Excel exam covers data validation rules — restrictions you apply to cells to control what users can enter. Tasks include creating drop-down lists from a range or manual list, setting numeric constraints (whole number, decimal, date, time, or text length restrictions), and writing custom validation formulas. Input messages and error alerts that guide users when they select or incorrectly fill a validated cell are also tested.

Tables and Named Ranges

Converting a range to an Excel Table (Insert > Table) and working with structured table references is a frequently tested skill. Excel Tables automatically expand to include new rows, support column-based structured references like [@Amount] that update dynamically, and provide built-in filter controls and banded row formatting. Named ranges — assigning a label to a cell or range and using that label in formulas — are tested for both creating names and using them in formulas and data validation rules.

Cell and number formatting tasks include applying custom number formats (currency, percentage, date formats, text formatting with @), merging and centering cells, applying cell styles, and protecting worksheets and workbooks with passwords. The exam may also include tasks related to printing setup: print areas, page breaks, headers and footers, and scaling options.

Performance-Based Exam Format

One important difference between the MOS Excel exam and most other certification exams is that it is entirely performance-based. You do not answer multiple-choice questions — you complete tasks directly in a live Excel environment. Each task describes what needs to be done ("In the Sales_Data table, add a conditional formatting rule that highlights cells in the Revenue column greater than 50000 with a yellow fill") and you must carry out the exact action using the correct Excel feature.

This format means that reading about Excel concepts is not enough preparation on its own. You need hands-on practice performing the specific tasks that appear on the exam. The PDF practice questions in this download are written in a task-style format to help you bridge the gap between conceptual understanding and task execution, but you should always follow up by actually performing the described operation in Excel to confirm you know the steps.

Differences Between Excel 2019, 2021, and 365

The three current MOS Excel exam versions differ primarily in which functions and features are available. Excel 365 includes all features from Excel 2019 and 2021 plus newer additions like dynamic array functions (FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY), XLOOKUP, XMATCH, and LET. Excel 2021 includes XLOOKUP, XMATCH, and some dynamic array functions. Excel 2019 does not include XLOOKUP or dynamic array functions.

When you register for the MOS exam, select the version that matches the Excel installed on your workplace or school computers. There is no advantage to taking the 365 exam unless you are confident working with the newer functions, as it introduces additional content not present on the 2019 exam. The PDF questions in this download note which function or feature applies to which version where relevant.

Preparing with the Exam Objective Map

Microsoft publishes a detailed exam skills outline for each MOS Excel version, listing every objective grouped by domain. Before your exam, go through the objective map line by line and honestly rate your confidence with each item. Any objective you cannot confidently complete in under two minutes is a practice priority. Pay particular attention to objectives involving the Format menu, Table Tools, PivotTable Tools, and Chart Tools contextual ribbons, since these are the areas where candidates most often lose time searching for the right option during the exam.

The MOS Excel certification is one of the more approachable professional credentials available — it does not require years of experience, and focused preparation over two to four weeks is enough for most candidates with basic spreadsheet familiarity. The key is hands-on practice in a live Excel environment, not just reading. Use this PDF to identify your knowledge gaps, then fill them by working through actual tasks in Excel. For full-length timed practice tests and topic-specific question sets, visit our excel practice test page.