I85PREP
⌘ K
MO-210 study materials
MO-210 study resources

MO-210 practice questions

One question at a time. Build your MO-210 understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Manage worksheets and workbooks

You need to bring a table from a public website into a worksheet and be able to refresh it later when the page changes. Which command should you use?

  1. Insert > Table
  2. Insert > PivotTable
  3. Review > Links
  4. Data > Get Data > From Web Correct answer.

Explanation

Get Data > From Web creates a query connection to the web page, so the imported table can be refreshed later without re-importing. Pasting the table instead would leave only static values in the cells.

Question 2Manage worksheets and workbooks

What is the maximum number of characters Excel allows in a worksheet tab name?

  1. 255
  2. 64
  3. 31 Correct answer.
  4. 15

Explanation

A worksheet name can contain up to 31 characters. It also cannot be blank and cannot contain the characters : \ / ? * [ ].

Question 3Manage worksheets and workbooks

Which command keeps row 1 visible on screen while you scroll down to row 500?

  1. Zoom > Fit Selection
  2. New Window > Arrange
  3. Freeze Panes > Freeze Top Row Correct answer.
  4. Split Window > Horizontal

Explanation

Freezing panes locks the rows above and the columns to the left of the active cell so they stay in place while the rest of the sheet scrolls. Freeze Top Row locks row 1 only.

Question 4Manage worksheets and workbooks

You want row 1 to appear at the top of every printed page. Which page setup option do you use?

  1. Print area
  2. Header/footer
  3. Page breaks
  4. Print titles Correct answer.

Explanation

Print Titles (Page Layout > Print Titles) sets rows to repeat at the top and columns to repeat at the left of every printed page. A header repeats text, but not the actual cell content.

Question 5Manage worksheets and workbooks

Which keyboard shortcut inserts a new worksheet in the active workbook?

  1. Alt+F11
  2. Shift+F11 Correct answer.
  3. Ctrl+F11
  4. F11

Explanation

Shift+F11 inserts a new worksheet before the active sheet. The other function-key combinations perform different tasks, such as creating a chart sheet or opening the VBA editor.

Question 6Manage worksheets and workbooks

You right-click a sheet tab and choose Move or Copy. Which action creates a duplicate of the sheet in the same workbook?

  1. Selecting Create a copy, then clicking OK Correct answer.
  2. Selecting the sheet itself as the reference
  3. Choosing (move to end), then clicking OK
  4. Clicking OK with the default settings

Explanation

Move or Copy relocates the sheet unless the Create a copy check box is selected. With Create a copy selected, the original stays where it is and a duplicate is placed at the chosen position.

Question 7Manage worksheets and workbooks

Which command enlarges the worksheet so that the currently selected cells fill the window?

  1. Page Layout > Scale to Fit > Width
  2. View > Zoom > 100%
  3. View > Page Layout
  4. View > Zoom > Zoom to Selection Correct answer.

Explanation

Zoom to Selection sets the zoom percentage so the selected range fills the visible window. Scale to Fit affects only the printed output, not the on-screen magnification.

Question 8Manage worksheets and workbooks

A colleague sends a workbook whose tabs show only 'Summary', even though you know other sheets exist. What should you do to display them?

  1. Press Ctrl+Page Down until the tab appears
  2. Right-click a tab and choose Unhide Correct answer.
  3. Click File > Info > Check for Issues
  4. Click Formulas > Show Formulas

Explanation

Hidden sheets have no visible tab, and the Unhide command on the sheet tab shortcut menu lists them so they can be restored. Ctrl+Page Down cycles only through sheets that are already visible.

Question 9Manage worksheets and workbooks

Which feature divides the worksheet window into two or four panes that you can scroll independently, without locking any rows or columns?

  1. Freeze Panes
  2. New Window
  3. Arrange All
  4. Split Correct answer.

Explanation

Split creates resizable panes inside one window, and each pane scrolls freely. Freeze Panes looks similar but actually locks the rows and columns in place.

Question 10Manage worksheets and workbooks

You need to watch a total in cell A1 on Sheet1 while editing data in Sheet2 of the same workbook. Which approach lets you see both at once?

  1. Group both sheets, then click Split
  2. Open the file twice from disk
  3. Freeze panes on both worksheets
  4. Click New Window, then Arrange All Correct answer.

Explanation

New Window opens a second window onto the same workbook, and Arrange All tiles the windows so different sheets or areas are visible simultaneously. Edits made in one window appear immediately in the other.

Question 11Manage worksheets and workbooks

Which feature stores a named combination of hidden rows and columns, column widths, filter settings, and print settings?

  1. Sheet protection
  2. Freeze Panes
  3. Data validation
  4. Custom Views Correct answer.

Explanation

Custom Views on the View tab saves the current display and print configuration under a name so you can switch between configurations quickly. Hidden rows and columns, column widths, filters, and print settings are all captured.

Question 12Manage worksheets and workbooks

Excel refuses to hide a worksheet when which condition is true?

  1. It is the active worksheet
  2. The sheet contains a chart
  3. The sheet contains a table
  4. It is the only visible worksheet Correct answer.

Explanation

A workbook must always contain at least one visible sheet, so Excel blocks the command when the sheet you are hiding would be the last visible one. Hiding the active sheet is otherwise allowed because Excel activates another sheet automatically.

Question 13Manage worksheets and workbooks

You want to stop users from adding, deleting, or renaming worksheets while still allowing them to edit cells. Which command do you use?

  1. Review > Protect Sheet
  2. Review > Protect Workbook > Windows
  3. Review > Protect Workbook > Structure Correct answer.
  4. File > Info > Protect Workbook > Encrypt with Password

Explanation

Protecting the workbook structure blocks sheet-level changes such as inserting, deleting, renaming, moving, or hiding sheets. Protecting a worksheet instead restricts what can be done to the cells on that sheet.

Question 14Manage worksheets and workbooks

You want only the range A1:F20 on the current sheet to be printed. Which command do you use?

  1. Page Layout > Print Area > Set Print Area Correct answer.
  2. Page Layout > Breaks > Insert Page Break
  3. File > Print > Print Active Sheets
  4. Page Layout > Print Titles

Explanation

Set Print Area defines the range that will print and excludes everything else on the sheet until the print area is cleared. Print Titles and page breaks change how pages look, not which cells are included.

Question 15Manage worksheets and workbooks

A worksheet prints with a single extra column spilling onto a second page. Which setting fits all the columns on one page without unnecessarily shrinking the rows?

  1. Choosing Fit to 1 page wide Correct answer.
  2. Choosing Landscape orientation
  3. Clearing the print area
  4. Choosing Narrow margins

Explanation

The Fit to option in Page Setup scales the output, and setting 1 page wide while leaving the height box blank shrinks the sheet only as much as needed to fit the columns. Changing orientation or margins may not be enough to eliminate the overflow.

Question 16Manage worksheets and workbooks

Rows 5 and 6 contain data, and you need three blank rows between them. Which action accomplishes this?

  1. Selecting rows 6 to 8 and clicking Insert > Insert Sheet Rows Correct answer.
  2. Selecting rows 5 to 7 and pressing Ctrl+X
  3. Selecting rows 8 to 10 and pressing Delete
  4. Selecting rows 5 to 7 and clicking Insert > Insert Sheet Rows

Explanation

Insert Sheet Rows adds as many rows as are selected, directly above the first selected row. Selecting rows 6 through 8 therefore inserts three blank rows above row 6, which places them between rows 5 and 6.

Question 17Manage worksheets and workbooks

You need to apply the same header and footer to five worksheets at once. What is the most efficient approach?

  1. Opening Page Setup on each sheet and typing the header five times
  2. Typing the header text into row 1 of the first worksheet
  3. Grouping the five sheet tabs, setting the header, then ungrouping Correct answer.
  4. Setting the header on one sheet, then using Format Painter on the other tabs

Explanation

When sheets are grouped, page setup changes such as headers and footers are applied to every sheet in the group at once. Group with Ctrl+click for non-adjacent tabs or Shift+click for adjacent tabs, then ungroup when finished.

Question 18Manage worksheets and workbooks

Which command produces a PDF that preserves the print area, page breaks, and headers?

  1. File > Print with the Microsoft OneNote printer
  2. Home > Copy, then pasting into a word-processing file
  3. File > Export > Create PDF/XPS Correct answer.
  4. File > Save As with the .xlsb format

Explanation

Exporting with Create PDF/XPS renders the workbook using its print layout, so the print area, page breaks, and headers are carried over into the PDF. Saving in a binary workbook format keeps a spreadsheet, not a PDF.

Question 19Manage worksheets and workbooks

You want a cell to jump to a defined range named Q4Data on another sheet when it is clicked. Which Link option do you use?

  1. Create New Document
  2. E-mail Address
  3. Place in This Document Correct answer.
  4. Existing File or Web Page

Explanation

The Place in This Document option lists the sheets and defined names in the current workbook, which is how internal navigation links are built. The other options point outside the workbook.

Question 20Manage worksheets and workbooks

Where do you set the Title, Author, and Company information that appears in a workbook's file details?

  1. Home > Format > AutoFit
  2. Review > Protect Workbook
  3. Insert > Header & Footer
  4. File > Info > Properties Correct answer.

Explanation

Workbook properties, reached through File > Info > Properties, store metadata such as Title, Author, Subject, and Company. This metadata appears in file details and can be inserted into headers and fields.

Question 21Manage worksheets and workbooks

You need a copy of the active worksheet placed in a different workbook that is already open. Which step in the Move or Copy dialog accomplishes this?

  1. Choosing the target in the To book list and checking Create a copy Correct answer.
  2. Saving the source workbook as .xlsm first
  3. Grouping both workbooks, then dragging the sheet tab
  4. Copying all the cells and pasting them into the other file

Explanation

The To book list selects the destination workbook, and Create a copy keeps the original sheet in place while adding a duplicate to the target. Without the check box, the sheet would be moved out of the source workbook.

Question 22Manage worksheets and workbooks

Which single setting prints cell gridlines without adding any formatting to the cells themselves?

  1. Page Setup > Margins
  2. Sheet Options > Print gridlines Correct answer.
  3. Home > Borders > All Borders
  4. View > Gridlines

Explanation

Printing gridlines is a Sheet Options setting on the Page Layout tab and is independent of the on-screen gridline display. Using borders instead applies real cell formatting that becomes part of the data.

Question 23Manage worksheets and workbooks

Which header code produces text such as 'Page 3 of 12'?

  1. &[Page] of &[Pages] Correct answer.
  2. &[Date] &[Time]
  3. &[File] &[Tab]
  4. &[Path]&[File]

Explanation

In headers and footers, &[Page] returns the current page number and &[Pages] returns the total number of pages in the print job. Combining the two with the word 'of' produces output such as 'Page 3 of 12'.

Question 24Manage worksheets and workbooks

You select cell B2 and click Freeze Panes. Which rows and columns remain visible when you scroll?

  1. Rows 1 and 2 only
  2. Column A only
  3. Row 2 and column B
  4. Row 1 and column A Correct answer.

Explanation

Freezing panes at the active cell locks every row above it and every column to its left. With B2 selected, that means row 1 and column A stay fixed while everything else scrolls.

Question 25Manage worksheets and workbooks

You select cell C5 and then click Page Layout > Breaks > Insert Page Break. Where does the break take effect?

  1. Beside column C, but not above row 5
  2. Below row 5 and to the right of column C
  3. Above row 5 and to the left of column C Correct answer.
  4. Above row 5, but not beside column C

Explanation

A manual page break is inserted above and to the left of the selected cell, so the printout splits at that point both vertically and horizontally. To create only a horizontal break, select a cell in column A before inserting it.

Question 26Manage worksheets and workbooks

Which keyboard shortcut inserts a new worksheet into the active workbook?

  1. Ctrl+F11
  2. Alt+F11
  3. Ctrl+Shift+F1
  4. Shift+F11 Correct answer.

Explanation

Shift+F11 inserts a new worksheet immediately before the active sheet and names it with the next available sheet number. The other key combinations open developer tools or do nothing in a standard workbook.

Question 27Manage worksheets and workbooks

Which shortcut key moves the active cell to the next worksheet in the workbook?

  1. Ctrl+Page Down Correct answer.
  2. Ctrl+Page Up
  3. Ctrl+Tab
  4. Alt+Page Down

Explanation

Ctrl+Page Down activates the next sheet tab to the right, and Ctrl+Page Up moves one sheet to the left. The sheet that becomes active keeps its own active cell.

Question 28Manage worksheets and workbooks

You want the Summary sheet tab to appear green so it stands out from the other tabs. What should you do?

  1. Right-click the tab and choose Tab Color Correct answer.
  2. Choose a green table style on the Table Design tab
  3. Set a green sheet background from Page Layout
  4. Apply a green cell fill to cell A1 of that sheet

Explanation

The Tab Color command on a sheet tab's shortcut menu recolors the tab itself. Tab colors are a visual aid on screen only and do not affect cells or printed output.

Question 29Manage worksheets and workbooks

What is the maximum number of characters allowed in a worksheet name?

  1. 64
  2. 127
  3. 15
  4. 31 Correct answer.

Explanation

Excel limits sheet names to 31 characters. Names also cannot be blank and cannot contain the characters : \ / ? * [ ].

Question 30Manage worksheets and workbooks

A long report must show the column labels in rows 1 through 3 at the top of every printed page. Which setting achieves this?

  1. Enter 1:3 in the Print Area box
  2. Repeat the labels inside the page header
  3. Enter 1:3 in the Print Titles box Correct answer.
  4. Freeze rows 1 through 3 before printing

Explanation

Rows or columns entered as print titles repeat on every printed page. The setting lives on the Page Layout tab next to Print Area but controls repetition rather than the extent of the printed range.

Question 31Manage worksheets and workbooks

Column A of a worksheet is hidden, so the first visible column header is B. Which approach selects column A so that it can be unhidden?

  1. Drag one column to the left from the column B header
  2. Type A1 in the Name Box, then use Unhide Columns Correct answer.
  3. Press Ctrl+Home, then press Shift+Spacebar
  4. Run Go To Special with Visible cells only selected

Explanation

Typing a reference such as A1 in the Name Box selects a cell in the hidden column, after which Format > Hide & Unhide > Unhide Columns restores it. Selecting the whole sheet and unhiding also works.

Question 32Manage worksheets and workbooks

You want to indicate that a workbook is finished and open it in a read-only state for reviewers. Which command should you use?

  1. Review > Protect Sheet with a password
  2. Review > Protect Workbook > Structure
  3. File > Info > Protect Workbook > Encrypt with Password
  4. File > Info > Protect Workbook > Mark as Final Correct answer.

Explanation

Mark as Final flags the file as complete, sets it to read-only on open, and displays a completion notice. It is a courtesy flag rather than security, because any user can remove it by clicking Mark as Final again.

Question 33Manage worksheets and workbooks

Before emailing a workbook, you want to locate and remove comments, hidden rows and columns, and personal information stored in the file. Which tool do you use?

  1. File > Info > Check for Issues > Inspect Document Correct answer.
  2. Home > Clear > Clear All
  3. Review > Check Compatibility
  4. View tab, clearing the Gridlines and Headings check boxes

Explanation

Document Inspector scans the file for hidden content, comments, metadata, and similar items, and can remove whatever categories you select. It runs on a copy of the saved data and reports what it found.

Question 34Manage worksheets and workbooks

Reviewers must be able to open a workbook without a password, but they must supply a password before changing it. Which Save As option do you set?

  1. Password to open
  2. Password to modify Correct answer.
  3. Read-only recommended
  4. Encrypt with Password

Explanation

Password to modify lets anyone open the file, but anyone who does not know the password gets a read-only copy. Password to open, by contrast, blocks access to the file entirely until the correct password is entered.

Question 35Manage worksheets and workbooks

You need to view Sheet1 and Sheet4 of the same workbook at the same time on one monitor. Which sequence accomplishes this?

  1. View > Split, then arrange the panes
  2. View > Freeze Panes applied to each sheet
  3. View > Switch Windows and pick the other sheet
  4. View > New Window, then View > Arrange All Correct answer.

Explanation

New Window opens a second window on the same workbook, and Arrange All tiles the windows so each can display a different sheet. Edits made in either window appear in the other because both show the same file.

Question 36Manage worksheets and workbooks

Which view shows a worksheet with its margins, headers, and footers exactly as they will print, while still allowing data entry?

  1. Custom Views
  2. Page Layout view Correct answer.
  3. Page Break Preview
  4. Normal view

Explanation

Page Layout view renders the page with margins, headers, and footers visible and keeps the cells editable. Normal view omits page furniture, and Page Break Preview emphasizes page breaks rather than a print-accurate page.

Question 37Manage worksheets and workbooks

Excel closed unexpectedly and the file you were building was never saved manually. Where can you try to retrieve it?

  1. Home > Undo, and repeat until the file returns
  2. File > Info > Manage Workbook > Recover Unsaved Workbooks Correct answer.
  3. Review > Protect Workbook > Unshare Workbook
  4. File > Open > Recent, then pick the file from the recent list

Explanation

AutoRecover keeps drafts of unsaved workbooks, and the Recover Unsaved Workbooks command opens the folder containing them so a draft can be restored. The recovered file should then be saved immediately under a proper name.

Question 38Manage worksheets and workbooks

You delete a worksheet that contained important data and then press Ctrl+Z. What is the result?

  1. Nothing changes; deleted worksheets are not restored by Undo Correct answer.
  2. The sheet returns with all of its data and formatting
  3. The sheet returns with its values but without its formatting
  4. Excel asks you to confirm before restoring the sheet

Explanation

Deleting a worksheet is not recorded in the undo history, so Ctrl+Z cannot bring the sheet back and the Undo command is typically unavailable. Recovery depends on a backup, a previous version, or a copy of the file.

Question 39Manage worksheets and workbooks

You save a workbook in the Excel 97-2003 file format and want to know which features will be lost or behave differently. Which command reports this?

  1. Check for Issues > Check Compatibility Correct answer.
  2. Review > Workbook Statistics
  3. Review > Check Accessibility, and read the report
  4. Formulas > Evaluate Formula

Explanation

The Compatibility Checker compares the workbook against the capabilities of the target file format and lists features that will be dropped or altered. It runs automatically when saving to a legacy format and can also be run on demand.

Question 40Manage worksheets and workbooks

A workbook you downloaded opens with a yellow message bar stating that editing is blocked, and the cells cannot be changed. What is the appropriate action?

  1. Clear Read-only recommended in the Save As dialog
  2. Reinstall Excel, because the file must be corrupted
  3. Click Enable Editing on the message bar Correct answer.
  4. Save the file to OneDrive and reopen it

Explanation

Files from the internet or from email attachments open in Protected View, a restricted mode that blocks editing until the user approves the content. Clicking Enable Editing leaves Protected View and makes the workbook fully editable; the file itself is intact.

Question 41Manage data cells and ranges

You copy a range of cells and want to paste only the fill color, borders, and font settings onto another range. Which Paste Special option should you choose?

  1. Formulas
  2. Values
  3. Comments and Notes
  4. Formats Correct answer.

Explanation

The Formats option pastes only the formatting attributes of the copied cells, such as fill, borders, font, and number format, without transferring the underlying content. Use Values or Formulas when the data itself is what you need to move.

Question 42Manage data cells and ranges

A cell contains the text Monday. You drag its fill handle down four cells using the default AutoFill behavior. What appears in the filled cells?

  1. A prompt asking you to choose a custom list
  2. Blank cells, because text entries cannot be filled
  3. Monday in all five cells
  4. Tuesday, Wednesday, Thursday, and Friday Correct answer.

Explanation

Excel recognizes built-in lists such as days of the week and months, so dragging the fill handle extends the series instead of repeating the value. To repeat the same entry, hold Ctrl while dragging or choose Copy Cells from the AutoFill Options button.

Question 43Manage data cells and ranges

Cells A1, B1, and C1 each contain a different value. You select A1:C1 and click Merge & Center. What happens to the values?

  1. All three values are combined into one text string
  2. Only the value in A1 is kept Correct answer.
  3. All three values are kept and shown in a comment
  4. The merge is blocked because the cells are not empty

Explanation

Merging retains only the content of the upper-left cell of the selection; Excel warns that the remaining values will be deleted. Any data you need from the other cells should be moved elsewhere before the merge is applied.

Question 44Manage data cells and ranges

A long product description in cell A2 spills across empty neighboring cells. Which command keeps the text inside A2 and displays it on multiple lines?

  1. Wrap Text Correct answer.
  2. Merge & Center
  3. Shrink to fit
  4. Orientation

Explanation

Wrap Text breaks the entry at the current column width and increases the row height so the full text stays inside a single cell. Shrink to fit instead reduces the font size so the text remains on one line.

Question 45Manage data cells and ranges

Which of these is a valid way to begin a defined name in Excel?

  1. With the letters R and C followed by digits
  2. With an underscore Correct answer.
  3. With a cell reference such as A1
  4. With a digit

Explanation

Defined names must start with a letter, an underscore, or a backslash, and they cannot be identical to a cell reference. Spaces are not permitted, so words are usually separated with an underscore or a period.

Question 46Manage data cells and ranges

Where does a sparkline appear after you insert it with Insert > Sparklines > Line?

  1. Inside the selected Location cell Correct answer.
  2. In the worksheet header area
  3. In a floating chart object above the data
  4. On a dedicated chart sheet

Explanation

A sparkline is a miniature chart drawn inside one cell; the Data Range supplies the values and the Location Range identifies the cell that holds the graphic. It moves and resizes with its cell rather than floating above the grid.

Question 47Manage data cells and ranges

You want a column to be exactly as wide as its longest entry. What is the quickest action?

  1. Drag the column header to the right until all the text fits
  2. Press Ctrl+0 with the column selected
  3. Choose Home > Format > Hide & Unhide
  4. Double-click the right boundary of the column heading Correct answer.

Explanation

Double-clicking the boundary between two column headings runs AutoFit, sizing the column to its widest entry. The same result is available from Home > Format > AutoFit Column Width.

Question 48Manage data cells and ranges

Which command on the Conditional Formatting menu removes every rule from the selected cells?

  1. Top/Bottom Rules
  2. Highlight Cells Rules
  3. New Rule
  4. Clear Rules Correct answer.

Explanation

Conditional formatting rules are stored separately from cell contents and cell formats, so they must be removed with the Clear Rules commands. Clearing formats or pressing Delete leaves the rules in place.

Question 49Manage data cells and ranges

You copied the values in A1:A6 and want them to appear across row 3 instead of down a column. Which Paste Special option do you select?

  1. Transpose Correct answer.
  2. Add
  3. Values
  4. Skip blanks

Explanation

Transpose swaps rows and columns when pasting, so a vertical range becomes horizontal and vice versa. It is available in the Paste Special dialog box and as the Transpose icon on the Paste menu.

Question 50Manage data cells and ranges

Cell C1 contains 100. You copy a cell containing 10, select C1, and use Paste Special with the Multiply operation. What does C1 contain afterwards?

  1. 1000 Correct answer.
  2. 50
  3. 10
  4. 110

Explanation

The operation options in Paste Special combine the copied value with the destination value using the chosen arithmetic, so 100 multiplied by 10 gives 1000. The copied cell is unaffected and can be pasted again somewhere else.