MO-211 · free practice

MO-211 Excel Expert Practice Test

Protection, advanced formulas, macros, PivotTables and advanced charts. Try three real practice questions below, then get the full 7-day course.

MO-211, Excel Expert (Microsoft 365 Apps). 50 minutes of hands-on tasks. Skill areas: workbook options and settings, managing and formatting data, advanced formulas and macros, advanced charts and tables.

Practice questions

Valid macro name?
  1. FormatReport
  2. Format Report
  3. 1Report
  4. Format-Report

No spaces, no leading digit, no hyphens.

Users must enter a password to open the file.
  1. File › Info › Protect Workbook › Encrypt with Password
  2. Protect Sheet
  3. Allow Edit Ranges
  4. Hide the sheet

Encryption guards opening.

Let users edit B2:B10 on a protected sheet.
  1. Unlock those cells (or Allow Edit Ranges), then protect
  2. Hide them
  3. Protect Workbook
  4. Freeze them

Locked status only applies once the sheet is protected.

The 7-day plan

  1. Workbook options & sharing
  2. Fill & format data
  3. Advanced conditional formatting
  4. Logic & lookups
  5. Dates, analysis & troubleshooting
  6. Simple macros
  7. Advanced charts & PivotTables

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-211 course