MO-210 ยท free practice

MO-210 Excel Associate Practice Test

Workbooks, cells, tables, core formulas and charts. Start here. Try three real practice questions below, then get the full 7-day course.

MO-210, Excel Associate (Microsoft 365 Apps). 50 minutes of hands-on tasks in Excel, scaled score of 700 out of 1000 to pass.

Practice questions

The tax rate is in E1. The formula in C2 will be copied down and must always use E1.
  1. =B2*E1
  2. =B2*$E$1
  3. =$B$2*$E$1
  4. =B2*"E1"

$E$1 stays locked while B2 adjusts for each row.

Which number format lines currency symbols up at the left edge of the cell?
  1. Currency
  2. Accounting
  3. General
  4. Number

Accounting pins the symbol to the left. Currency keeps it next to the number.

What does a #SPILL! error mean?
  1. Division by zero
  2. Cells in the spill range aren't empty
  3. The function name is misspelled
  4. Circular reference

The results have nowhere to go. Clear the blocking cells.

The 7-day plan

  1. Workbooks & navigation
  2. Cells & ranges
  3. Make data talk
  4. Tables
  5. Formulas that score
  6. Dynamic arrays & text
  7. Charts

Every day has a visual lesson, an instant-graded check and smart review of anything you miss. It ends with a timed mock exam that draws new questions every time.

Get the full MO-210 course