MOS Cheat Sheet 2026

The 30 highest-yield MOS facts, distilled from real exam questions. Print it, save it as a PDF, or study it here — free, no sign-up.

1. What does the Excel function TODAY() return? → The current date only
2. What is the effect of setting a workbook's calculation mode to Manual? → Formulas only recalculate when you press F9 or save the file
3. Which alignment option centers content both horizontally and vertically within a table cell? → Align Center (Table Tools > Layout > Alignment > Align Center)
4. How do you change the cell margins (padding) for all cells in a Word table at once? → Table Tools > Layout > Alignment > Cell Margins
5. Which type of query in Access retrieves records from one or more tables based on specified criteria? → Select Query
6. You insert a new Slide Master. How many default slide layouts does PowerPoint create with it? → 11
7. Which Shape Format option merges two overlapping shapes by keeping only the area that is common to both? → Intersect
8. When you move a chart from the current worksheet to a separate chart sheet, the chart's data source: → Remains linked to the original worksheet
9. Which paragraph border option in Word adds a horizontal line only below the paragraph? → Bottom border
10. Which of the following options in the 'Table Style Options' group allows you to apply special formatting to alternating rows to improve readability? → Banded Rows
11. Which Picture Format command removes the background from a photo in Word? → Remove Background
12. Which Picture Format option lets you choose a specific color in the image to make fully transparent? → Color > Set Transparent Color
13. You want to prevent users from inserting or deleting worksheets in a workbook. Which option achieves this? → Workbook structure protection via Review > Protect Workbook
14. To link a chart title directly to a cell value so it updates automatically, you should: → Select the chart title, type = in the formula bar, then click the source cell
15. When you use 'Arrange All' under the View tab with multiple workbooks open, which arrangement option tiles windows side by side horizontally? → Vertical
16. Which Excel feature highlights cells that meet conditions you define, using color scales, data bars, or icon sets? → Conditional Formatting
17. Which view do you use to add a logo to all slides without editing each one individually? → Slide Master view
18. How can you change the text direction inside a table cell to read vertically? → Table Tools > Layout > Alignment > Text Direction
19. What is the primary purpose of using Slide Masters and Layouts in a PowerPoint presentation? → To ensure a consistent design, including fonts, colors, and logos, across all slides.
20. Which of these functions calculates the number of workdays between two dates, excluding weekends? → NETWORKDAYS
21. What is the primary function of the Relationships window in Microsoft Access? → To define, view, edit, and delete the relationships between database tables
22. To precisely set an image's height to 3.5 inches in Word, which is the most direct method? → Right-click the image and choose Format Picture, then set height in the Size pane
23. Which view in Outlook Calendar displays all seven days of the week in a grid with hourly time slots? → Week view
24. Which of the following correctly describes the 'Plot Area' of a chart? → The rectangular region bounded by the axes where data is plotted
25. In an Excel formula, what does the $ symbol do when placed before a column letter or row number? → Creates an absolute reference that does not change when copied
26. Which option in the Wrap Text menu allows other content to appear on both sides of an image simultaneously? → Square
27. In Word, what is a 'building block'? → Reusable content stored in the Quick Parts gallery
28. Which keyboard shortcut applies bold formatting to selected text in Word? → Ctrl+B
29. What happens when you set a field's Required property to 'Yes' in Access? → The field must have a value before the record can be saved
30. When using Effect Options for a text box animation, which option animates each paragraph separately? → By 1st Level Paragraphs