• 75 questions

Microsoft Office Specialist Practice Test

Word, Excel and PowerPoint in one bank: pick a program, and each answer links to its Microsoft Support article.

Which choice under Insert > Pictures in Word inserts a picture stored on your own computer?

Pick an answer, then press Check answer. Then you see Correct or Not quite, with the reason. Keys: A to D pick, Enter checks.

Print covers the next 30 questions. Share this set copies a link to the same questions in the same order.

Exam mode: 30 questions, no time limit.

More options

Unofficial practice questions, not affiliated with Microsoft or Certiport. Bank checked October 9, 2026.

Next step More Word: the Word certification testIC3 digital literacy practice test

All 75 questions

Word (exam MO-110) 25

  • A booklet will print on both sides, so inside margins must match each other and outside margins must match each other. Which choice under Multiple Pages in Word sets this? Microsoft Support: Set mirror margins for facing pages
  • A colleague uses an older version of Word. Which command under File > Info > Check for Issues lists the features of your document that the older version does not support? Microsoft Support: Check file compatibility with earlier versions
  • A list of addresses that you want to convert to a Word table has commas inside the addresses. Which separator should you put between the columns? Microsoft Support: Convert text to a table or a table to text
  • A picture in a Word document sits behind a block of text and cannot be clicked. Where do you select it? Microsoft Support: Wrap text and move pictures in Word
  • A report spells a client's name wrong in forty places. Which button in Word's Find and Replace changes every one in a single step? Microsoft Support: Find and replace text in Word
  • Before you choose Repeat Header Rows for a Word table, what must your selection include? Microsoft Support: Repeat table header on subsequent pages
Show all 75 questions (69 more)

Word (exam MO-110), continued

  • In Word, page 3 ends with an Even Page section break that you insert. On which page does the next section start? Microsoft Support: Insert a section break
  • In Word, which Link to option of the Insert Hyperlink dialog box lists the headings and bookmarks of the open document? Microsoft Support: Add hyperlinks to a location within the same document
  • On which Word tab is the Columns command, which lays out a whole document in columns? Microsoft Support: Create multiple columns in Word
  • On which Word tab is the Watermark command, with ready-made marks such as DRAFT and CONFIDENTIAL? Microsoft Support: Insert a watermark
  • One bullet in a Word list should drop to the second level. Which command on the Multilevel List menu does that? Microsoft Support: Change bullet indents in Word
  • Under Insert > Screenshot in Word, which tool captures only part of a window? Microsoft Support: Insert a screenshot or screen clipping
  • What do you type to make Word start a numbered list by itself? Microsoft Support: Create a bulleted or numbered list
  • What is the quickest way to add a basic table of three columns and four rows to a Word document? Microsoft Support: Insert a table
  • What margin does Word give each page of a new document automatically? Microsoft Support: Change margins
  • Where does Word place an endnote? Microsoft Support: Insert footnotes and endnotes in Word
  • Which choice under Insert > Pictures in Word inserts a picture stored on your own computer? Microsoft Support: Insert pictures
  • Which command in the Font group of Word returns selected text to its default formatting? Microsoft Support: Clear all text formatting
  • Which file format saves the text of a Word document with no formatting at all? Microsoft Support: File formats for saving documents
  • Which SmartArt type shows a continual process? Microsoft Support: Choose a SmartArt graphic
  • Which Word command ends the current page at the cursor and starts a new one? Microsoft Support: Insert a page break in Word
  • Which Word command opens the settings for a table of contents' tab leader and the number of heading levels it shows? Microsoft Support: Format or customize a table of contents in Word
  • Which Word command removes every comment from a document at once? Microsoft Support: Insert, delete, or change a comment
  • With Track Changes on in Word, how are deletions and additions marked? Microsoft Support: Track changes in Word
  • You have read every tracked change in a Word document and agree with all of them. Which choice in the Accept list takes them all in at once? Microsoft Support: Accept or reject tracked changes in Word

Excel (exam MO-210) 25

  • A column must show part codes exactly as typed, even when a code is all digits. Which Excel number format treats the content that way? Microsoft Support: Available number formats in Excel
  • A new Excel chart shows a legend, although you added none. Why? Microsoft Support: Add a legend to a chart
  • An Excel worksheet is split into panes. How do you remove the split? Microsoft Support: Split panes to lock rows or columns in separate worksheet areas
  • The Chart Styles gallery in Excel offers colors you do not want. Where do those colors come from? Microsoft Support: Change the color or style of a chart in Office
  • Custom Views is unavailable everywhere in an Excel workbook. What is the cause given in Microsoft Support? Microsoft Support: Create, apply, or delete a custom view
  • In an Excel table's filter list you want to show two regions only. What do you uncheck first? Microsoft Support: Filter data in a range or table in Excel
  • In Excel's Page Break Preview, what do dashed lines mark? Microsoft Support: Insert, move, or delete page breaks in a worksheet
  • In Excel, what sets a threaded comment apart from a note? Microsoft Support: The difference between threaded comments and notes
  • In the Excel reference B$4, what does the dollar sign fix when the formula is copied? Microsoft Support: Switch between relative, absolute, and mixed references
  • In which Excel view can you see and type a worksheet header on the sheet itself? Microsoft Support: Headers and footers in a worksheet
  • Which chart type uses one set of values, a single data series? Microsoft Support: Select data for a chart
  • Which check box adds a row of totals at the bottom of an Excel table? Microsoft Support: Total the data in an Excel table
  • Which Excel function counts the cells in a range that are not empty, whatever they hold? Microsoft Support: COUNTA function
  • Which Excel function turns every capital letter of a text string into lowercase? Microsoft Support: LOWER function
  • Which Home tab command in Excel shows long text on several lines inside one cell? Microsoft Support: Wrap text in a cell in Excel
  • Which of these is one of the three sparkline types in Excel? Microsoft Support: Use sparklines to show data trends
  • Which shortcut opens the dialog box for adding a link to the selected Excel cell? Microsoft Support: Work with links in Excel
  • Which shortcut opens the Number options of the Format Cells dialog box in Excel? Microsoft Support: Available number formats in Excel
  • Which Table Design command lets you pick a new range for an Excel table, so that it takes in more rows and columns? Microsoft Support: Resize a table by adding or removing rows and columns in Excel
  • While editing an Excel formula, which key switches the selected reference between relative, absolute and mixed? Microsoft Support: Switch between relative, absolute, and mixed references
  • You are not sure which chart suits your Excel data. Which Insert command has Excel analyze the data and suggest charts? Microsoft Support: Create a chart with recommended charts
  • You select a cell in Excel and want to give it a name. Where do you type the name before pressing Enter? Microsoft Support: Define and use names in formulas
  • You select a formatted Excel cell and press Delete. What is removed? Microsoft Support: Clear cells of contents or formats
  • You switch an Excel workbook to another document theme. What happens to the cell styles in use? Microsoft Support: Apply, create, or remove a cell style
  • You want to join the text of several Excel cells with a comma between the values. Which function takes a delimiter argument? Microsoft Support: CONCAT function

PowerPoint (exam MO-310) 25

  • A logo must appear on every slide of a PowerPoint presentation. Where do you add it once? Microsoft Support: What is a slide master in PowerPoint?
  • A PowerPoint show must loop at a trade-show booth until someone presses Esc. Which show type in Set Up Slide Show does that? Microsoft Support: Create a self-running presentation
  • An audio clip plays automatically on a PowerPoint slide. Which Playback option keeps its icon out of the show? Microsoft Support: Add or delete audio in your PowerPoint presentation
  • As you drag an object on a PowerPoint slide, red dashed lines appear. What are they? Microsoft Support: Guides for arranging things on a slide
  • By default, what does a PowerPoint screen recording capture along with the selected area? Microsoft Support: Record your screen in PowerPoint
  • The cursor is in the last cell of the last row of a PowerPoint table. Which key adds one more row at the end? Microsoft Support: Add a table to a slide
  • How many transition effects can one PowerPoint slide carry? Microsoft Support: The difference between animations and transitions
  • In the Format Shape pane of PowerPoint, after you choose Columns for a text box, which two boxes do you fill in? Microsoft Support: Create columns of text in a text box or shape
  • In the Insert Hyperlink dialog box of PowerPoint, what is a ScreenTip? Microsoft Support: Add a hyperlink to a slide
  • On which PowerPoint tab is the Use Presenter View check box? Microsoft Support: Use Presenter View in PowerPoint
  • Three shapes overlap on a PowerPoint slide. Which command moves the selected shape behind all the others? Microsoft Support: Layer objects on slides
  • Two PowerPoint animations should play at the same moment. Which Start setting do you give the second one? Microsoft Support: Set the start time and speed of an animation effect
  • Under which Picture Format command in PowerPoint do you find Soft Edges and Bevel? Microsoft Support: Format pictures on slides
  • What happens to a slide you hide in PowerPoint? Microsoft Support: Hide or show a slide
  • Which choice under Insert > Zoom in PowerPoint summarizes the entire presentation on one slide? Microsoft Support: Use zoom for PowerPoint to bring your presentation to life
  • Which Home tab command in PowerPoint turns a selected bulleted list into a diagram? Microsoft Support: Create a SmartArt graphic from a list in PowerPoint
  • Which Insert command in PowerPoint adds small graphics that you can rotate, color and resize with no loss of image quality? Microsoft Support: Insert icons in Microsoft 365
  • Which Picture Format command in PowerPoint adjusts the brightness, contrast or sharpness of a picture? Microsoft Support: Format pictures on slides
  • Which PowerPoint tool copies one object's animations to another object with one click? Microsoft Support: Duplicate animations with the animation painter
  • Which Print Layout choice in PowerPoint prints several slides on one page, some layouts with space for note-taking? Microsoft Support: Print your PowerPoint slides, handouts, or notes
  • Which Slide Show command in PowerPoint times each slide while you practice the talk? Microsoft Support: Rehearse and time the delivery of a presentation
  • You change a PowerPoint deck to a smaller slide size and want all content to stay on the slides. Which option do you pick when prompted? Microsoft Support: Change the size of your PowerPoint slides
  • You convert a SmartArt graphic on a PowerPoint slide to shapes. What can you no longer do? Microsoft Support: Convert your SmartArt graphic into shapes
  • You reuse a slide from another PowerPoint file. By default, which design does the copied slide take? Microsoft Support: Reuse (import) slides from another presentation
  • You want no transition effect between slides 2 and 3 of a PowerPoint show. From which slide do you remove the transition? Microsoft Support: Add, change, or remove transitions between slides

How this list was compiled: Own questions, sorted by program and written to Microsoft's skills outlines for three Microsoft Office Specialist exams (Microsoft 365 Apps): MO-110 Word (https://learn.microsoft.com/en-us/credentials/certifications/mos-word-associate-m365-apps/), MO-210 Excel (https://learn.microsoft.com/en-us/credentials/certifications/mos-excel-associate-m365-apps/) and MO-310 PowerPoint (https://learn.microsoft.com/en-us/credentials/certifications/mos-powerpoint-associate-m365-apps/), each page and the outline PDF it links to read 2026-10-09. Facts were read on 2026-10-09 in Microsoft Support articles at support.microsoft.com. Each question names the article it was written from and links to it. Licence: Own work. Every question, wrong choice and explanation was written for this site from the public Microsoft Support articles named in each question. Nothing is copied or reworded from a Microsoft Office Specialist exam, a Certiport or GMetrix practice product or a question dump.

How it works

An unofficial Microsoft Office Specialist (MOS) practice test in three parts: 25 of our own questions each on Word, Excel and PowerPoint. This site is not affiliated with, endorsed by or sponsored by Microsoft or Certiport.

Read the full guide

The three exams this test follows

Each MOS certification is one exam on one program. This bank follows Microsoft's skills outlines, read on October 9, 2026, for Word (MO-110), Excel (MO-210) and PowerPoint (MO-310), all in the Microsoft 365 Apps version. Inside each program the questions are spread near that exam's published weights.

What is not asked here

The real exams are tasks done inside each program, so this is a knowledge check and not a simulation. The Expert exams for Word and Excel, the Excel specialty exams, and the Office 2019 exams for Outlook and Access are left out. Formula results are on the Excel certification page.

  • On a PowerPoint slide master, one change reaches every slide that is based on that master.
  • Press F4 while editing an Excel formula to switch a reference between relative, absolute and mixed.
  • A Word section break set to Even Page at the end of page 3 starts the next section on page 4.

Questions and answers

How many questions are on a MOS exam?

Certiport's exam lengths page, read on October 9, 2026, gives 33 to 37 for each of Word, Excel and PowerPoint and 23 to 27 for the two Expert exams. Every one of them lasts 50 minutes and covers a single program.

Are MOS exams multiple choice?

No. They are live-in-the-application, in Microsoft's words: you are given tasks and carry them out in the program. A knowledge test like this one shows which commands to go and practice there.

What is a passing score on the MOS exam?

700, on the scale of 1 to 1000 that Certiport uses for its exams. Microsoft adds that the score needed depends on the exam. The result here is a count of right answers by program, with no pass or fail.

Is there still a MOS 2013 or 2016 practice test?

No current exam matches one. The MOS 2016 certifications were retired on June 30, 2026, and Certiport's list now holds Microsoft 365 Apps and Office 2019 exams. These questions follow three Microsoft 365 Apps outlines.

More tests

Show 7 more

Browse Safety and Trades