Microsoft MO-200 Actual Free Exam Questions & Community Discussion

  • Exam Code/Number: MO-200
  • Exam Name/Title: Microsoft Excel (Excel and Excel 2019)
  • Certification Provider: Microsoft
  • Corresponding Certification: Microsoft Office Specialist
  • Exam Questions: 32
  • Updated On: Jul 13, 2026
You are compiling data about courses at Bellows College.
On the ''Last Semester'' worksheet configure A3:F3 to automatically wrap the text.
Check the Solution below.
Correct Answer:
Click wrap text.
On the ''New Policies'' worksheet, in cells J5:J13, insert Win/Loss sparkllines to compare the January through June values.
Check the Solution below.
Correct Answer:
Select a blank cell and press insert. Pick win/loss sparklines. Select the data range. Click and drag the bottom right corner for more.
Topic 6, Enrollment



On the 'Enrolment Summary'' worksheet, name the range A3:B7 ''Enrollment'', Check the Solution below.
Correct Answer:
Select the range and type the name
On the ''Revenue'' worksheet, convert cells A3:B7 to a table with headers. Apply the Green, Table Style Light 14 style.
Check the Solution below.
Correct Answer:
Select a cell within your data. Press home and then format as table. Click the table style and select your range.
0
0
0
10