MOS Study Guide 2026
Everything you need to pass the MOS exam in one place: the exam format, every topic to study, real practice questions with explanations, flashcards, and full-length practice tests. Free, no sign-up needed.
📋 MOS Exam Format at a Glance
📚 MOS Topics to Study (63)
✍️ Sample MOS Questions & Answers
1. What does the 'Send Update' button do when you modify an existing meeting you organized?
After modifying a meeting, clicking Send Update pushes the revised details to all invitees so their calendars reflect the changes.
2. When you freeze panes in Excel, where does the freeze line appear relative to the selected cell?
Freeze Panes freezes all rows above and all columns to the left of the currently selected cell.
3. What is the maximum number of rows supported in an Excel worksheet (Excel 2016 and later)?
Excel 2007 and later versions support up to 1,048,576 rows per worksheet.
4. Which formula correctly uses an absolute reference so that C1 does not change when the formula is copied down column D?
Using $C$1 locks both the column and row of C1, so it remains constant when the formula is copied in any direction.
5. To add a trendline to a chart, you must first:
A trendline is added to a specific data series, so you must select that series before accessing the Add Trendline option.
6. In Outlook, what is the function of the 'Junk Email' filter?
The Junk Email filter automatically evaluates incoming messages and moves suspected spam to the Junk Email folder.