MO-210 case studies
MO-210 · Put your knowledge to work in context.
MO-210, listed by Microsoft as Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps), is an intermediate-level certification that verifies you can use the core features of Excel in the Microsoft 365 Apps environment. Microsoft positions it for business users who can create and manage worksheets and workbooks, create cells and ranges, create tables, apply formulas and functions, and create charts and objects - including multi-sheet workbooks and charts that present data visually. The MO-210 case studies are 5 cases and about 3,637 words.
1The 3D Reference That Never Grew
Your team maintains MonthlyOps.xlsx: twelve data sheets named Jan through Dec, all with an identical layout, plus a Summary sheet whose cell C5 is =SUM(Jan:Dec!C10). In March a colleague inserts a sheet called "Q1 Notes" at the far right.
683 words, about 3 min2The Roster That Counted Sixty People Twice Too Few
An HR analyst keeps an 850-row roster on a sheet named Roster: A EmployeeID, B Department, C Start Date, D Salary. A named range EmpID was created while Roster was the active sheet, with Roster chosen in the Name Manager's Scope box.
687 words, about 3 min3Eighteen Rows In, Twelve Rows Out
Purchasing maintains tblOrders on sheet Orders with columns OrderID, Date, Region, Rep, Cost, Amount, and a calculated column Margin whose formula is =[@Amount]-[@Cost]. The table has a Totals row.
759 words, about 4 min4The Commission Model That Mistrusts Its Own Boundaries
Sales ops builds a commission model. Sheet Data holds a table with columns Rep, Region, Sales and Target.
737 words, about 4 min5The Dashboard That Lost December
Finance's dashboard has one clustered column chart of monthly Revenue with a line series for Margin % on a secondary axis. The series are hard-wired to Data!
771 words, about 4 min