UUS Practice Tests⌕ Search
IT Certifications · MO-200

Exam MO-200: Microsoft Excel (Office 2019) Practice Test

MO-200: Microsoft Excel (Office 2019) covers spreadsheet work such as entering formulas, organizing data, applying formatting, and preparing worksheets for charts or print. The available practice questions use examples involving functions such as AVERAGE and MAX, automatic dates, formula errors, data validation, chart selection, and page setup. These tasks relate to building, checking, and presenting useful workbook content.

Exam overview

Exam providerMicrosoft
Exam codeMO-200
CategoryIT Certifications

About the Exam MO-200: Microsoft Excel (Office 2019) Exam

Excel work involves choosing functions that match a calculation, understanding how formulas respond to cell values, and identifying causes of errors such as #DIV/0!. Data validation helps control what users can enter, while workbook settings can preserve a desired opening view. Formatting and chart choices affect how clearly a worksheet communicates values and comparisons; a pie chart, for example, can show categories as parts of a whole. Printed output requires separate decisions, including page orientation and repeating a header row across pages. Practice with these tasks can sharpen the judgment needed to select the right command or function for a specific spreadsheet outcome, rather than relying on trial and error.

Sample Practice Questions

Review a selection from this exam's published US Practice Tests practice bank.

Question 1

In a worksheet, you want a formula to show the current date and update automatically when the workbook recalculates. Which function should you enter?

  1. ADATEVALUE
  2. BTODAY
  3. CDAY
  4. DDATE
Show answerCorrect answer: B

TODAY returns the current date as a date value and updates when Excel recalculates. DATE constructs a date from year, month, and day arguments, while DAY extracts a day number.

Question 2

You have a list in cells A1:A10 and want to restrict repeated values from being entered in A1:A10. Which Data Validation setting is appropriate?

  1. AAllow: Custom, with a formula that checks whether the entry already exists
  2. BAllow: Any value
  3. CAllow: Date
  4. DAllow: Text length
Show answerCorrect answer: A

A custom validation formula can test whether the proposed value occurs elsewhere in the range, allowing Excel to reject duplicates. The formula must be written relative to the active cell and account for the full range.

Question 3

Which formula returns the largest number in the range C3:C18?

  1. A=HIGH(C3:C18)
  2. B=MAX(C3:C18)
  3. C=TOP(C3:C18)
  4. D=LARGE(C3:C18)
Show answerCorrect answer: B

MAX returns the largest numeric value in a range. LARGE also returns ranked values, but it requires a second argument specifying the rank.

Question 4

A formula returns the error #DIV/0!. What is the usual cause?

  1. AThe formula attempted to divide by zero or by an empty cell
  2. BThe formula references a worksheet that does not exist
  3. CA number in the formula is too large to display
  4. DThe formula uses an unrecognized function name
Show answerCorrect answer: A

Excel displays #DIV/0! when a formula divides a number by zero or by a cell that evaluates to zero, including a blank cell used as the divisor. Other errors indicate different problems.

Question 5

A workbook should open with a particular worksheet active and a particular cell selected. Which feature can save that opening state for the workbook?

  1. ACustom Views
  2. BWorkbook properties
  3. CSave a Workspace
  4. DProtect Workbook
Show answerCorrect answer: A

A Custom View can save display and print settings, including the active sheet and selected cell, for later recall. Availability can depend on workbook features such as Excel tables.

Question 6

You want a chart to show each product's contribution as a proportion of a whole, with the category values forming a single total. Which chart type is a suitable choice?

  1. APie chart
  2. BScatter chart
  3. CStock chart
  4. DSurface chart
Show answerCorrect answer: A

A pie chart represents categories as parts of one whole, making it suitable for showing proportions when the categories sum to a meaningful total. Scatter charts focus on relationships between numeric values.

Question 7

You want a cell to show a line break between two pieces of text joined by a formula. Which function can insert the line-break character in Excel for Windows?

  1. ACHAR(10)
  2. BCHAR(13)
  3. CCODE(10)
  4. DCLEAN(10)
Show answerCorrect answer: A

CHAR(10) returns the line-feed character commonly used for an in-cell line break in Excel for Windows. The cell may also need Wrap Text enabled for the break to display on separate lines.

How to use this practice test

Access is free. When questions are published for this exam, a session presents up to 20 random items from the practice bank. Submit your answers to see results, then use missed or uncertain questions to identify which Excel functions, data controls, chart choices, or print settings need more attention.

Preparation tips

  • Write and compare formulas using AVERAGE, MAX, and TODAY; check how each behaves with blank cells and changing dates.
  • Trace common formula errors such as #DIV/0! back to the referenced values and division operation before changing the formula.
  • Configure Data Validation for a range and test whether the setting prevents duplicate entries in the intended cells.
  • Create a chart from sample category values, then check whether its type communicates parts of a whole clearly.
  • Use Print Titles and page orientation settings, then preview multiple pages to confirm that the header row repeats as intended.
Official sourceOfficial exam page ↗