MO-210 Exam Flashcards

Q: What is the current MO-210 exam format?

MO-210 is a proctored, in-application Microsoft Office Specialist exam. You complete Excel projects and tasks in 50 minutes. Microsoft and Certiport do not publish a fixed task count, so claims of a guaranteed number of questions should not guide your pacing.

Q: How are these 50 cards distributed across the official MO-210 skills outline?

Microsoft publishes ranges, not exact weights: Manage Worksheets and Workbooks 25–30%, Manage Data Cells and Ranges 25–30%, Manage Tables and Table Data 10–15%, Perform Operations by Using Formulas and Functions 15–20%, and Manage Charts 15–20%. Normalizing the range midpoints and applying whole-card rounding gives 13, 13, 6, 9, and 9 cards.

Q: What score is required to pass MO-210?

The published MO-210 passing score is 700 on a 1,000-point scaled scale. A scaled 700 should not be interpreted as exactly 70% of tasks or clicks correct because scoring reflects the assessed skills and task structure.

Q: What is the MOS retake policy?

After the first unsuccessful MO-210 attempt, wait 24 hours. After the second unsuccessful attempt, wait 48 hours before the third and every later retake. The MOS policy lists no annual attempt limit, and each attempt may require a new fee or voucher.

Q: Does the MO-210 credential expire?

MOS credentials earned on or after September 23, 2025 are valid for five years from their issue date. MOS credentials earned before that policy start date remain non-expiring.

Q: Does MO-210 test XLOOKUP, PivotTables, macros, or Power Query?

Those are not named in the current MO-210 Associate skills outline. MO-210 names core references and functions such as SUM, IF, SORT, UNIQUE, and text functions, plus standard tables and charts. Study only the published Associate scope before adding expert tools.

Q: How is MO-210 different from MO-211?

MO-210 validates associate-level Excel skills in everyday workbooks, ranges, tables, core functions, and charts. MO-211 is the Excel Expert exam and covers more advanced workbook settings, data formatting, formulas and macros, and advanced charts and tables.

Question 1

When importing a delimited text file, what should you verify before loading it into Excel?

Accepted Answer

Confirm the delimiter, file origin or encoding, detected column data types, header handling, and destination. A wrong delimiter or automatic type conversion can corrupt the structure before the data reaches the worksheet.

Question 2

What is the practical advantage of importing an online data source through Get Data?

Accepted Answer

Excel creates a query-backed connection that can preserve transformation steps and refresh from the source. Loading copied web text directly creates only a static snapshot.

Question 3

How do Find and the Name Box serve different navigation goals?

Accepted Answer

Find searches workbook content such as text or values. The Name Box jumps directly to a cell address, named range, table, or other defined workbook element when you enter its name.

Question 4

What can an Excel hyperlink target besides a web page?

Accepted Answer

It can open an existing file, create an email message, or jump to a cell or named location in the current workbook. Removing the hyperlink can leave the displayed text intact.

Question 5

Which page-setup choices control how a worksheet fits on printed pages?

Accepted Answer

Orientation, paper size, margins, print area, page breaks, and scaling. Use print preview to confirm that fitting the sheet does not make the content unreadably small.

Question 6

How does AutoFit differ from assigning a row height or column width?

Accepted Answer

AutoFit sizes the row or column to its current contents. Assigning a specific measurement creates a fixed size that does not automatically expand when longer content is entered.

Question 7

Where do custom headers and footers appear in a workbook?

Accepted Answer

They appear on printed pages and in Page Layout view, not as ordinary worksheet cell content. They can include text plus fields such as page number, date, file name, or sheet name.

Question 8

Why customize the Quick Access Toolbar for an MO-210 workflow?

Accepted Answer

It keeps selected commands available regardless of the active ribbon tab. Add commands you use repeatedly; this changes the interface, not the workbook's data or formulas.

Question 9

What remains visible after you choose Freeze Panes?

Accepted Answer

Rows above and columns to the left of the active-cell boundary remain visible while you scroll. Freeze Top Row and Freeze First Column are simpler presets for one direction.

Question 10

Why open a New Window for the same workbook?

Accepted Answer

It lets you display different sheets or distant areas of one workbook at the same time. Arrange or View Side by Side changes the windows; it does not create another workbook copy.

Question 11

What is the difference between workbook properties and Show Formulas?

Accepted Answer

Properties store descriptive metadata such as title, author, tags, and subject. Show Formulas switches the worksheet display from calculated results to the formulas stored in cells.

Question 12

How do Print Area and exporting to PDF solve different tasks?

Accepted Answer

Print Area selects which cells will print from the workbook. Exporting to PDF creates a separate fixed-layout file, using the current print area and print settings unless you change the export options.

Question 13

Before distributing a workbook, what should you inspect and review?

Accepted Answer

Use inspection tools for hidden properties, personal information, accessibility, and compatibility as required; then resolve comments and review legacy notes. Comments support threaded discussion, while notes are simple cell annotations.

Question 14

Which Paste Special choice removes formulas but preserves their displayed results?

Accepted Answer

Paste Values. Other Paste Special choices can preserve only formulas or formatting, apply arithmetic, skip blanks, or transpose rows and columns, so choose the option that matches the requested result.

Question 15

How does Auto Fill decide what to place in adjacent cells?

Accepted Answer

It copies a value or formula, extends a recognized series, or follows a pattern based on the selected seed cells and fill option. Relative references adjust when formulas are filled.

Question 16

What is the key difference between inserting an entire row and inserting selected cells?

Accepted Answer

An inserted row shifts every column in that row position. Inserting selected cells shifts only the chosen area right or down, which can misalign a dataset if the wrong scope is selected.

Question 17

What does =RANDBETWEEN(10,20) return, and why might it change?

Accepted Answer

It returns a random integer from 10 through 20, inclusive. RANDBETWEEN is volatile, so the result can change whenever Excel recalculates the workbook; paste values to freeze a result.

Question 18

What does =SEQUENCE(3,2,10,5) spill into the worksheet?

Accepted Answer

A 3-row by 2-column array containing 10, 15, 20, 25, 30, and 35 in row order. The four arguments are rows, columns, starting value, and step.

Question 19

What happens to data when multiple cells are merged?

Accepted Answer

Excel keeps the upper-left cell's content and discards content from the other selected cells after warning you. Unmerging later restores separate cells but does not restore discarded values.

Question 20

How do Wrap Text, orientation, and indentation affect a cell?

Accepted Answer

Wrap Text displays content on multiple lines within the cell width; orientation rotates the displayed content; indentation offsets it from the cell edge. These are alignment formats and do not alter the stored value.

Question 21

Does applying a currency or date number format change the underlying value?

Accepted Answer

No. Number formatting changes how the value appears, while formulas still use the stored number. Format Painter copies formatting from one selection to another without copying its value.

Question 22

How do a cell style and Clear Formats differ?

Accepted Answer

A cell style applies a reusable bundle of formatting such as number format, font, fill, border, and alignment. Clear Formats removes formatting while leaving values and formulas in place.

Question 23

Why group worksheets before applying formatting?

Accepted Answer

The same edit can be applied to corresponding cells on every grouped sheet. Ungroup immediately afterward, because later typing, deletion, or formatting would otherwise affect all grouped sheets.

Question 24

What benefit does a named range provide in a formula?

Accepted Answer

It replaces an address with a meaningful stable name, such as =SUM(SalesAmount). A name can have workbook or worksheet scope, so choose the correct scope when defining or referencing it.

Question 25

What does a sparkline show that a standard cell value does not?

Accepted Answer

A sparkline is a miniature line, column, or win/loss chart inside one cell that summarizes a row or column of values. Its location cell is separate from its source data range.

Question 26

What determines whether conditional formatting is displayed?

Accepted Answer

Excel reevaluates the rule against the cell's current value or formula. Rule order and Stop If True can affect conflicts; removing a rule removes the visual format, not the underlying data.

Question 27

What does converting a range to an Excel table add?

Accepted Answer

A header-aware structured object with filtering, sorting, styles, calculated-column behavior, structured references, and automatic expansion. Confirm whether the source already has headers when creating it.

Question 28

What is the difference between a table style and table style options?

Accepted Answer

The style supplies the overall visual design. Options such as Header Row, Total Row, First or Last Column, Banded Rows, and Banded Columns toggle structural emphasis within that design.

Question 29

What remains after Convert to Range is applied to a table?

Accepted Answer

The data and current formatting remain, but table functionality is removed: structured table behavior, automatic expansion, table-name references, and built-in table filter controls no longer operate as a table.

Question 30

How can you expand a table without overwriting unrelated worksheet data?

Accepted Answer

Insert table rows or columns from within the table, or enter data directly next to its boundary when the adjacent area is clear. Verify the selection so an entire worksheet row or column is not inserted accidentally.

Question 31

Why does a table Total Row commonly use SUBTOTAL instead of SUM?

Accepted Answer

SUBTOTAL can ignore rows hidden by a table filter, so the result reflects visible records. Use the Total Row dropdown to choose Sum, Average, Count, or another supported calculation per column.

Question 32

How do filtering and a multi-level sort differ in a table?

Accepted Answer

Filtering temporarily hides records that fail criteria without rearranging the remaining data. A multi-level sort reorders all records using prioritized keys, such as Department first and Sales descending second.

Question 33

How do relative, absolute, and mixed references behave when a formula is filled?

Accepted Answer

A1 lets both row and column move; $A$1 locks both; $A1 locks only the column; A$1 locks only the row. F4 cycles these forms while editing a selected reference.

Question 34

In a table formula, what does [@Amount] mean?

Accepted Answer

It is a structured reference to the Amount value in the current table row. By contrast, Table1[Amount] refers to the data cells in the entire Amount column.

Question 35

Which core functions answer total, average, smallest, and largest?

Accepted Answer

SUM totals numeric values, AVERAGE returns their arithmetic mean, MIN returns the smallest numeric value, and MAX returns the largest. Text and blanks in referenced ranges are generally ignored by these calculations.

Question 36

How do COUNT, COUNTA, and COUNTBLANK differ?

Accepted Answer

COUNT counts cells containing numbers; COUNTA counts nonempty cells of any type; COUNTBLANK counts blank cells in the specified range. Choose based on the stored content, not how a formatted cell looks.

Question 37

What are the three required parts of an IF function?

Accepted Answer

A logical test, a result if the test is TRUE, and a result if it is FALSE: =IF(logical_test,value_if_true,value_if_false). Text results need quotation marks.

Question 38

What does the SORT function return?

Accepted Answer

A dynamically spilled, sorted copy of an array or range. It does not rearrange the source data; optional arguments choose the sort index, order, and whether to sort by row or column.

Question 39

What does UNIQUE do with a source list?

Accepted Answer

It returns distinct values as a dynamic array while leaving the source unchanged. The result spills into neighboring cells, so occupied cells in the spill area cause a #SPILL! error.

Question 40

When should you use LEFT, RIGHT, or MID?

Accepted Answer

Use LEFT for characters from the beginning, RIGHT for characters from the end, and MID for characters beginning at a specified position. MID requires both a starting position and a character count.

Question 41

Which named MO-210 functions change text case, measure text, or join text?

Accepted Answer

UPPER and LOWER change letter case; LEN counts characters including spaces; CONCAT joins text without a delimiter argument; TEXTJOIN can insert a chosen delimiter and optionally ignore empty cells.

Question 42

What should you decide before inserting a chart?

Accepted Answer

Choose the data and the comparison the chart must communicate. Column or bar charts compare categories, line charts emphasize change over an ordered axis, and pie charts are best limited to a simple part-to-whole relationship.

Question 43

How does Excel determine the initial chart data from a selection?

Accepted Answer

Excel uses the selected values and nearby headers to infer series names and category labels. Select the intended range first, then verify the resulting series and axis labels rather than accepting the inference blindly.

Question 44

How does a chart sheet differ from an embedded chart?

Accepted Answer

A chart sheet contains a chart as the sheet's primary content. An embedded chart is an object positioned on a worksheet alongside cells and can be moved or resized there.

Question 45

What must be defined when adding another data series to a chart?

Accepted Answer

Provide the series name and the range containing its values, then confirm the category labels still align. A mismatched range size can produce misleading categories or missing points.

Question 46

What does Switch Row/Column change in a chart?

Accepted Answer

It swaps the chart's interpretation of source rows and columns as series versus category groups. It does not transpose or alter the worksheet source data.

Question 47

Which chart element explains each data series, and which identifies an axis?

Accepted Answer

The legend maps colors or markers to series. Axis titles describe the meaning or units of an axis; a chart title states the chart's overall message or subject.

Question 48

When are data labels more useful than a legend alone?

Accepted Answer

Data labels place values, percentages, category names, or series names next to individual points. Use only the information needed, because excessive labels can obscure the chart.

Question 49

How does a Quick Layout differ from a chart style?

Accepted Answer

A Quick Layout changes the arrangement and presence of elements such as titles, legends, and labels. A chart style changes coordinated colors and visual formatting without redefining the source data.

Question 50

What should useful alternative text for a chart communicate?

Accepted Answer

State the chart's purpose and the essential trend, comparison, or conclusion a viewer needs. Do not merely repeat 'chart' or list decorative details; alt text exists for users who cannot see the visual.

Free MO-210 Exam Flashcards

Filter by Topic

Jump to Card

About These MO-210 Flashcards

Topics Covered

Frequently Asked Questions

Microsoft Excel (Microsoft 365 Apps) (MO-210)

Explore More Microsoft Certifications

Microsoft Power BI Data Analyst

Microsoft 365 Endpoint Administrator (MD-102)

Microsoft Certified: Security, Compliance, and Identity Fundamentals (SC-900)

Microsoft Power Platform Developer (PL-400)

Microsoft Power Platform Fundamentals (PL-900)

Microsoft Certified: Identity and Access Administrator Associate (SC-300)

More From This Family