• 82 questions

Excel Certification Practice Test

Questions on the five skill areas of MOS exam MO-210, with formulas to work out from a small grid.

Which shortcut inserts a new note in the selected cell?

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 35 questions. Share this set copies a link to the same questions in the same order.

Exam mode: 35 questions, 50 minutes.

More options

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

Next step Next: Word certification testWord, Excel and PowerPoint: MOS test

All 82 questions

Manage worksheets and workbooks 21

  • A cell holds a link to a web page. How do you turn off that one link and keep the cell's text? Microsoft Support: Work with links in Excel
  • A print area is set, and now the whole worksheet should print again. Which Page Layout command do you click? Microsoft Support: Set or clear a print area on a worksheet
  • A wide sheet should print across one page and run down as many pages as it needs. What do you enter beside Fit to in Page Setup? Microsoft Support: Page Setup
  • A worksheet has two print areas. How do they print? Microsoft Support: Set or clear a print area on a worksheet
  • Find returns nothing, although the value is on another sheet of the same file. Which Find option widens the search to every sheet? Microsoft Support: Find or replace text and numbers on a worksheet
  • How do you put a ribbon command on the Quick Access Toolbar? Microsoft Support: Customize the Quick Access Toolbar
  • In a delimited text file with the extension .txt, which character typically separates each field? Microsoft Support: Import or export text (.txt or .csv) files
Show all 82 questions (75 more)

Manage worksheets and workbooks, continued

  • In Normal view, in which unit does Excel measure row height? Microsoft Support: Change the column width and row height
  • In the Find what box, which wildcard stands for exactly one character? Microsoft Support: Find or replace text and numbers on a worksheet
  • What do you type in a header box so that the printed header reads 'Smith & Lee'? Microsoft Support: Headers and footers in a worksheet
  • What is the fastest way to autofit every column on a worksheet? Microsoft Support: Change the column width and row height
  • Which command in the Get & Transform Data group of the Data tab imports a .csv file into a workbook? Microsoft Support: Import or export text (.txt or .csv) files
  • Which entry in the box labelled Rows to repeat at top prints row 1 at the top of every printed page? Microsoft Support: Repeat specific rows or columns on every printed page
  • Which feature saves a worksheet's hidden columns, filter settings and print settings under one name, so that you can apply them again later? Microsoft Support: Create, apply, or delete a custom view
  • Which function key opens the Go To dialog box, where you can jump to a named range? Microsoft Support: Select specific cells or ranges in Excel
  • Which keyboard shortcut switches a worksheet between showing formulas and showing their results? Microsoft Support: Display or hide formulas
  • Which shortcut inserts a new note in the selected cell? Microsoft Support: Insert comments and notes in Excel
  • With cell C3 selected, you choose View > Freeze Panes > Freeze Panes. What stays in view as you scroll? Microsoft Support: Freeze panes to lock rows and columns
  • You paste a web address into Data > From Web, pick a table in the Navigator pane and select Load. How does the data arrive on the sheet? Microsoft Support: Import data from the web
  • You select row 13 and choose View > Split. Where does the split fall? Microsoft Support: Split panes to lock rows or columns in separate worksheet areas
  • You want the first two columns to stay in view as you scroll right. Which column do you select before choosing View > Freeze Panes > Freeze Panes? Microsoft Support: Freeze panes to lock rows and columns

Manage data cells and ranges 21

  • A cell holds 0.25. You apply the Percentage number format. What does the cell show? Microsoft Support: Available number formats in Excel
  • A1 holds 'North' and B1 holds 'South'. You select A1:B1 and merge the cells. What does the merged cell show? Microsoft Support: Merge and unmerge cells in Excel
  • Copied data runs across row 1. Which paste option lays it down column A? Microsoft Support: Paste options
  • In Excel for the web you want to insert three rows in one step. How many rows do you select before you right-click and choose Insert Rows? Microsoft Support: Insert or delete rows and columns in Excel
  • On the Sparkline tab, which check box highlights the individual values along a line sparkline? Microsoft Support: Use sparklines to show data trends
  • The Paris and London sheets are grouped. You type a formula in B7 on Paris. What happens on London? Microsoft Support: Group worksheets
  • To group Sheet1 through Sheet4, you click the Sheet1 tab. Which key do you hold while clicking the Sheet4 tab? Microsoft Support: Group worksheets
  • Under Orientation in the Format Cells dialog box, what does 45 in the Degrees box do to the text of the selected cell? Microsoft Support: Align or rotate text in a cell
  • What do you enter before dragging the fill handle so that Auto Fill continues the series 5, 10, 15, 20? Microsoft Support: Fill data automatically in worksheet cells
  • What does =RANDBETWEEN(1,6) return? Microsoft Support: RANDBETWEEN function
  • What does =SEQUENCE(3,4) fill? Microsoft Support: SEQUENCE function
  • Where can you delete a name that was defined for a range? Microsoft Support: Select specific cells or ranges in Excel
  • Where does a sparkline sit? Microsoft Support: Use sparklines to show data trends
  • Which command under Home > Clear removes number formats and borders from the selected cells and leaves their values? Microsoft Support: Clear cells of contents or formats
  • Which number format lines up the currency symbols and the decimal points down a column? Microsoft Support: Available number formats in Excel
  • Which paste option pastes the results of copied formulas without the formulas, formatting or comments? Microsoft Support: Paste options
  • Which paste option puts a reference to the source cells in place of the copied contents? Microsoft Support: Paste options
  • While editing a cell, which keys start a new line of text inside that cell? Microsoft Support: Wrap text in a cell in Excel
  • You cut a formula from one cell and paste it into another. What happens to the cell references in it? Microsoft Support: Paste options
  • You name four ranges in one step with Formulas > Create from Selection. What scope do the new names have? Microsoft Support: Create a named range from selected cells in an Excel worksheet
  • You want to remove conditional formatting from the selected range and keep the rules on the rest of the sheet. Which command under Clear Rules do you choose? Microsoft Support: Use conditional formatting to highlight information in Excel

Manage tables and table data 10

  • A cell in a table's Total Row holds =SUBTOTAL(109,[Midwest]). What does it work out? Microsoft Support: Total the data in an Excel table
  • A formula uses a structured reference to a table. You turn the table into a range. What happens to the reference? Microsoft Support: Convert an Excel table to a range of data
  • A table is filtered to show ten of its two hundred rows. You open Find. Which rows does Find search? Microsoft Support: Filter data in a range or table in Excel
  • In Excel for the web you format a range as a table and leave My table has headers unchecked. What does Excel put above the data? Microsoft Support: Create and format tables
  • In the Sort dialog box, which button adds another column to sort by? Microsoft Support: Sort data in a range or table in Excel
  • Which of these will Excel accept as the name of a table? Microsoft Support: Rename an Excel table
  • Which table style option shades odd and even rows differently to make a table easier to read? Microsoft Support: Format an Excel table
  • You create the first table in a new workbook and give it no name. What does Excel call it? Microsoft Support: Rename an Excel table
  • You type a value in the cell just below the last row of an Excel table. What does the table do? Microsoft Support: Resize a table by adding or removing rows and columns in Excel
  • You want to keep the look of an Excel table and drop its table features. Which Table Design command, in the Tools group, does that? Microsoft Support: Convert an Excel table to a range of data

Perform operations by using formulas and functions 17

  • A1 holds Ana and B1 holds Ruiz. What does =CONCAT(A1," ",B1) return? Microsoft Support: CONCAT function
  • A1 holds NY, A2 is empty, A3 holds 14 and A4 holds B. What does =TEXTJOIN("-",TRUE,A1:A4) return? Microsoft Support: TEXTJOIN function
  • A1:A4 holds 10, 20, the text 'absent' and 30. What does =AVERAGE(A1:A4) return? Microsoft Support: AVERAGE function
  • A1:A4 holds 40, 15, 90 and 62. You enter =SORT(A1:A4,1,-1) in C1. What value shows in C1? Microsoft Support: SORT function
  • A1:A5 holds 12, 7, the text 'n/a', an empty cell and 9. What does =COUNT(A1:A5) return? Microsoft Support: COUNT function
  • A1:A5 holds 14, 3, the text 'void', 27 and 9. What does =MAX(A1:A5)-MIN(A1:A5) return? Microsoft Support: MAX function
  • A1:A6 holds Ann, 5, an empty cell, TRUE, 0 and Ben. What does =COUNTA(A1:A6) return? Microsoft Support: COUNTA function
  • A1:A6 holds East, West, East, North, West and East. How many cells does =UNIQUE(A1:A6) fill? Microsoft Support: UNIQUE function
  • B1:B5 holds 4, an empty cell, 0, an empty cell and the letter x. What does =COUNTBLANK(B1:B5) return? Microsoft Support: COUNTBLANK function
  • B2 holds 60. What does =IF(B2>=60,"Pass","Retake") return? Microsoft Support: IF function
  • C2 holds =A2*$B$1. You copy C2 and paste it into C3. What formula is in C3? Microsoft Support: Switch between relative, absolute, and mixed references
  • What does =LEN("Q3 total") return? Microsoft Support: LEN function
  • What does =LOWER(RIGHT("PLAN-B",1)) return? Microsoft Support: LOWER function
  • What does =MID("INV-2026-0417",5,4) return? Microsoft Support: MID function
  • What does =RIGHT("Room 204B",4) return? Microsoft Support: RIGHT function
  • What does =UPPER(LEFT("denver",3)) return? Microsoft Support: LEFT function
  • What does the structured reference DeptSales[Sales Amount] refer to in =SUM(DeptSales[Sales Amount])? Microsoft Support: Using structured references with Excel tables

Manage charts 13

  • A chart sits on a worksheet with its default settings. You widen the columns beneath it. What happens to the chart? Microsoft Support: Move or resize a chart
  • A chart's legend shows 'Series1'. In the Select Data dialog box, where do you type the right name after choosing Edit? Microsoft Support: Add a legend to a chart
  • A column chart shows the quarters along the horizontal axis and you want the regions there. Which Chart Design command swaps them? Microsoft Support: Change how rows and columns of data are plotted in a chart
  • The data for a new chart has 12 rows of months and 3 columns of regions. Which does Excel place on the horizontal axis? Microsoft Support: Change how rows and columns of data are plotted in a chart
  • How do you open the Alt Text pane for a chart? Microsoft Support: Video: Create more accessible charts in Excel
  • On the Chart Design tab, which command in the Chart Layouts group applies a predefined layout to the selected chart? Microsoft Support: Change the layout or style of a chart
  • One category should drop out of a chart while its data stays on the sheet. What do you do after right-clicking the chart? Microsoft Support: Update the data in an existing chart
  • Which button beside a selected chart holds the Legend check box? Microsoft Support: Add a legend to a chart
  • Which Chart Design command, in the Location group, places a chart on a new sheet? Microsoft Support: Move or resize a chart
  • Which entry under Chart Design > Add Chart Element adds a Linear or Moving Average line to a chart? Microsoft Support: Create a chart from start to finish
  • Which path adds a title to the vertical axis of a chart? Microsoft Support: Video: Create more accessible charts in Excel
  • Which path puts data labels at the outside end of each column in a chart? Microsoft Support: Video: Create more accessible charts in Excel
  • With the chart data selected, which keys create a chart at once? Microsoft Support: Create a chart from start to finish

How this list was compiled: Own questions, sorted by the five skill areas of Microsoft's skills outline for Exam MO-210: Microsoft Excel (Microsoft 365 Apps), linked from https://learn.microsoft.com/en-us/credentials/certifications/mos-excel-associate-m365-apps/ (the page and the Exam MO-210 skills outline PDF it links to were both 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, grid of values, 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 Excel certification practice test with 82 questions of our own. Neither Microsoft nor Certiport is affiliated with it. The real exam is done in a live workbook.

Read the full guide

What the Excel exam covers

Microsoft's skills outline for exam MO-210, read on October 9, 2026, weights five areas: worksheets and workbooks, 25 to 30 percent; data cells and ranges, 25 to 30; tables and table data, 10 to 15; formulas and functions, 15 to 20; charts, 15 to 20. The bank keeps close to those shares.

How the formula questions work

A formula question writes out a few cells as text and asks what the formula returns. Each result follows the function's Microsoft Support article, linked under the answer. The Excel Expert exam, MO-211, is left out.

  • AVERAGE, MAX and MIN ignore text in a range, and a cell that holds zero still counts.
  • Freeze Panes freezes the rows above the selected cell and the columns to its left.
  • Cut and paste leaves a formula's references alone. Copy and paste shifts the relative ones.

Questions and answers

Which functions are on the Excel certification exam?

The MO-210 outline names twenty: AVERAGE, MAX, MIN, SUM, COUNT, COUNTA, COUNTBLANK, IF, SORT, UNIQUE, RIGHT, LEFT, MID, UPPER, LOWER, LEN, CONCAT, TEXTJOIN, RANDBETWEEN and SEQUENCE. Each one stands in a question of this bank.

How long is the Excel certification exam?

50 minutes for 33 to 37 questions, done as tasks in a live workbook, by Microsoft Learn and Certiport's exam lengths page, both read on October 9, 2026. Exam mode on this page sets 35 of our questions against the same 50 minutes.

What score do you need to pass the Excel certification exam?

Certiport's scoring policy equates a pass to 700 on its scale of 1 to 1000, and Microsoft says the mark needed depends on the exam. Neither is a percent, so this page shows a score and no verdict.

Is there still an Excel 2016 certification practice test?

The MOS 2016 exams ended on June 30, 2026, by Certiport's retirements page. The Excel exams it offers now are for Microsoft 365 Apps and Office 2019. This bank follows the Microsoft 365 Apps outline, which names SORT, UNIQUE, SEQUENCE and TEXTJOIN.

Is this Excel practice test free?

Yes, all 82 questions with their explanations, and there is no sign-up. Print the paper test to work the formulas by hand.

More tests

Show 7 more

Browse Safety and Trades