MO-200 case studies
MO-200 · Put your knowledge to work in context.
The Microsoft Office Specialist: Excel Associate (Office 2019) credential, exam code MO-200, certifies that you can use Excel 2019 at a working professional level: creating and formatting workbooks, managing cells and ranges, building and filtering tables, writing formulas with core functions, and creating and formatting charts. It suits office administrators, analysts, students, and career changers who need verifiable proof of spreadsheet skill rather than a certificate of attendance. The MO-200 case studies are 5 cases and about 3,017 words.
1Regional workbook: print setup, external links, and structure protection
Your team maintains a workbook named RegionalSales.xlsx with 14 worksheets: a Summary sheet, 12 regional sheets (one per sales region), and a Notes sheet. The regional sheets were created by copying a template, so they share the same layout, and the Summary sheet uses 3D references such as =SUM(East:West!D10).
649 words, about 3 min2Weekly CSV import: mixed dates, refund duplicates, repeatable load
A colleague exports order data from a web storefront to Orders.csv each Monday. The file has 5,200 rows and columns OrderID, OrderDate, Region, and Amount.
592 words, about 3 min3Expanding expense table: calculated column, PivotTable refresh, filtering
A workbook tracks 2,400 project expenses in a table named ExpenseTbl on a sheet named Data. Columns are ProjectID, Phase, Vendor, InvoiceDate, Hours, Rate, and a calculated column Cost with =[@Hours] [@Rate].
593 words, about 3 min4Tiered commission: lookup mode, unmatched reps, blank revenue
A sales compensation workbook has a Reps sheet with RepID, Name, Region, and Quota; a Deals sheet with DealID, RepID, CloseDate, Product, and Revenue; and a Tiers sheet listing monthly commission rates with lower bounds in column A (0, 50000, 100000, 200000) and rates in column B (2%, 4%, 6%, 8%). You must calculate each rep's monthly commission.
577 words, about 3 min5Dashboard chart: expanding source, gaps, secondary axis, template
A chart on the Dashboard sheet plots monthly revenue for four product lines from a range on Data!A1:E13 (Month in A, products in B:E). The range is a plain range, not a table.
606 words, about 3 min