MCAS Cheat Sheet 2026

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

1. Which command allows users to change the color scheme and look of a Microsoft Office interface? → Office Theme
2. What file format must you use to save an Excel workbook that contains macros? → .xlsm
3. In Outlook, what does flagging an email message do? → Marks the email for follow-up, making it easy to find and track later
4. What is the keyboard shortcut to open the Macro dialog box in Excel? → Alt + F8
5. In Excel, what must you do before creating a chart from worksheet data? → Select the data range you want to include in the chart
6. In Excel, what is the correct syntax to calculate 15% of the value in cell B2? → =B2*15%
7. In Outlook, how do you add a personal email signature that automatically appears in new messages? → File > Options > Mail > Signatures > New
8. Which keyboard shortcut opens the Visual Basic Editor in Microsoft Office? → Alt + F11
9. In Excel, what is the purpose of a secondary axis in a chart? → To plot a data series with a different scale on the right side of the chart
10. In Excel, what does a cell reference like $A$1 (with dollar signs) indicate? → An absolute reference that does not change when the formula is copied to another cell
11. Which VBA construct is used to make decisions in a macro based on a condition? → If...Then...Else
12. In Outlook, what does the 'CC' field in an email message stand for and how is it used? → Carbon Copy — sends a copy to additional recipients who are not the primary addressees
13. Which shortcut key combination is used to copy selected text in Microsoft Office? → Ctrl + C
14. In Outlook, which view in the Calendar module shows one full week with hourly time slots? → Week view
15. Which keyboard shortcut opens the Save As dialog box in most Microsoft Office applications? → F12
16. In Microsoft Word, what does the 'Compatibility Mode' indicator in the title bar mean? → The file was created in an older version of Word and some features may be disabled
17. Which feature in Microsoft Word corrects spelling and grammar errors as you type? → AutoCorrect
18. In Microsoft Excel, which chart type is best suited for showing trends over time with continuous data? → Line chart
19. In PowerPoint, how do you align multiple selected objects so their left edges line up? → Drawing Tools > Format > Align > Align Left
20. In Microsoft Word, which option in the Print dialog allows you to print only specific pages of a document? → Page Range
21. What is a 'Personal Macro Workbook' in Excel? → A hidden workbook that stores macros available in all Excel sessions
22. Which menu option allows users to manage add-ins and extensions in Microsoft Office applications? → Options → Add-ins
23. In Microsoft Word, which feature allows you to insert a reusable block of text or graphics that is stored and accessed quickly? → Quick Parts (AutoText)
24. In PowerPoint, which keyboard shortcut starts the slide show from the beginning? → F5
25. What is the purpose of the Ribbon in Microsoft Office applications? → Organizes commands and tools into tabs and groups
26. How can you change the default file format for saving documents in Microsoft Word? → In the Save tab under Options
27. In Microsoft Office, what language are macros written in? → VBA (Visual Basic for Applications)
28. In Excel, which function rounds a number DOWN to the nearest integer regardless of decimal value? → INT
29. In Microsoft Word, how do you insert a table with a specific number of rows and columns? → Insert tab > Table > Insert Table (specify rows and columns)
30. Which Microsoft Office application is primarily used for creating text-based documents? → Microsoft Word