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. Which type of query in Access retrieves records from one or more tables based on specified criteria? → Select Query
2. 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
3. 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.
4. What is the primary function of the Relationships window in Microsoft Access? → To define, view, edit, and delete the relationships between database tables
5. 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
6. What is the primary purpose of a Report object in Microsoft Access? → To present data in a formatted, printable document
7. Which of the following actions can be automatically performed on INCOMING messages by creating an Outlook Rule? → Move the message to a specific folder
8. Which of these options describes how the document's personal information is provided? → Document Property
9. Which field property in Access allows you to specify a condition that all entered data must satisfy before it can be saved? → Validation Rule
10. Where should you look if the Excel drop-down menu doesn't have the Quick Access Toolbar option? → More Commands' at the bottom of the drop-down menu
11. If you select the "Options" button in the "Find" dialogue box, what additional Find options will appear? → All of the above
12. Which form control in Access provides a dropdown list of predefined values for data entry? → Combo Box
13. In Access Query Design View, what is the purpose of the 'Criteria' row? → To filter records based on conditions they must meet
14. Which option is utilized at the bottom of each page to display the document's creation date and page number? → Footer
15. Which of the following is used to navigate through lengthy documents by clicking on the small images at the bottom of each page? → Thumbnail
16. What is the primary purpose of a primary key in an Access table? → To uniquely identify each record in the table
17. To correct the text as it is typed, which of the following will you use? → AutoCorrect
18. Which type of Access action query creates a brand-new table using the records returned by the query? → Make-Table Query
19. To create a seamless visual effect where a logo on Slide 2 appears to move smoothly from its position on Slide 1, which transition should be applied to Slide 2? → Morph
20. Which Access object is specifically designed to automate repetitive tasks by executing a series of predefined actions? → Macro
21. To automatically arrange text around a picture, which of the following options is used? → Text Wrapping
22. Which of the following is NOT a valid data type in Microsoft Access? → Formula
23. Which field or box would you enter "California" into if you wished to replace out "Boulder" with "Anaheim"? → Replace With:
24. What term refers to the way the text is arranged on a page? → Pagination
25. What is the name of the small square located in the lower right corner of a selected cell or range? → The Fill Handle
26. What is a subform in Microsoft Access? → A form embedded within another form to display related records
27. In a document, which of the following is used to navigate through the structural view? → Document Map
28. You have been invited to a meeting in Outlook. Which of the following is NOT a standard, built-in response option you can send to the organizer? → Forward to Manager
29. What is referential integrity in Microsoft Access? → A set of rules that maintain consistency between records in related tables
30. What is the shortcut for copying text? → Ctrl + C