Microsoft Certified Application Specialist (MCAS) Exam — Questions and Answers

Question 1: In Excel, what does it mean to 'format a range as a table'?

It locks the cells so they cannot be edited
It creates a pivot table from the selected data
It converts the range into a structured table with automatic filtering, styling, and dynamic range management (Correct answer)
It merges all selected cells into one

Correct answer: It converts the range into a structured table with automatic filtering, styling, and dynamic range management

Formatting as a table gives the range automatic filter drop-downs, banded row styling, and the ability to reference the table by name in formulas.

Question 2: Which feature allows you to send a document as a PDF directly from Microsoft Word?

Track Changes
Export as PDF (Correct answer)
Zoom
Print Preview

Correct answer: Export as PDF

The 'Export as PDF' feature in Microsoft Word allows users to convert their document directly into a Portable Document Format (PDF) file. This is highly useful for sharing documents that need to maintain their formatting and layout consistently across different devices and operating systems. PDF files are also generally more secure and difficult to alter than original Word documents.

Question 3: Which Excel function returns the largest value in a range of cells?

HIGH
MAX (Correct answer)
TOP
LARGE

Correct answer: MAX

The MAX function returns the largest numeric value found within the specified range.

Question 4: Which tab in Microsoft Office applications lets you customize the Ribbon?

Home
Review
File (Correct answer)
Insert

Correct answer: File

To customize the Ribbon in Microsoft Office applications, you typically navigate to the 'File' tab, then select 'Options', and from there, choose 'Customize Ribbon'. The File tab provides access to back-end settings and options for the application, including personalization of the user interface. This allows users to tailor the Ribbon to their specific workflow and preferences.

Question 5: Which Microsoft cloud storage service is commonly used for storing and sharing Office files online?

Power BI
Paint 3D
OneDrive (Correct answer)
Windows Media Player

Correct answer: OneDrive

OneDrive is Microsoft's cloud storage service, deeply integrated with the Office suite. It allows users to store, sync, and share files and folders across multiple devices and with other people. Storing Office files on OneDrive enables features like co-authoring, version history, and secure access from anywhere, making it ideal for collaborative work and data backup.

Question 6: When recovering an unsaved Word document, where would you typically look first?

The AutoRecover file location set in Word Options (Correct answer)
The Documents library default folder
The Windows Recycle Bin
The OneDrive version history

Correct answer: The AutoRecover file location set in Word Options

Word stores AutoRecover files in a location specified in Word Options > Save, which is where unsaved documents can be recovered.

Question 7: What is the purpose of the Ribbon in Microsoft Office applications?

Displays email messages
Monitors internet connection
Organizes commands and tools into tabs and groups (Correct answer)
Plays background music

Correct answer: Organizes commands and tools into tabs and groups

The Ribbon in Microsoft Office applications serves as the primary interface for accessing commands and tools. Its purpose is to organize these functionalities into logical tabs and groups, making it easier for users to find and utilize features relevant to their current task. This design enhances user efficiency and discoverability compared to older menu-based systems.

Question 8: Which feature in Microsoft Office allows you to set a password that prevents others from opening a file?

Restrict Editing
Mark as Final
Encrypt with Password (under File > Info > Protect Document) (Correct answer)
Digital Signature

Correct answer: Encrypt with Password (under File > Info > Protect Document)

The 'Encrypt with Password' option under File > Info > Protect Document requires a password to open the file.

Question 9: Which command allows users to change the color scheme and look of a Microsoft Office interface?

Gridlines
Office Theme (Correct answer)
Paragraph Styles
Smart Lookup

Correct answer: Office Theme

The 'Office Theme' command allows users to change the overall color scheme and visual appearance of the Microsoft Office interface. Options like 'Colorful,' 'Dark Gray,' 'Black,' or 'White' are available, letting users personalize their working environment. This feature primarily affects the look of the application window itself, rather than document content.

Question 10: In Excel, what file format preserves ONLY the data values (no formatting or formulas) and is widely used for data exchange?

XLSM
CSV (Correct answer)
XLS
XLSX

Correct answer: CSV

CSV (Comma-Separated Values) stores only plain data, making it universally compatible for data exchange between different programs.

Question 11: In Microsoft Word, which option in the Print dialog allows you to print only specific pages of a document?

Page Range (Correct answer)
Print One Sided
Collated
Duplex Printing

Correct answer: Page Range

The Page Range option lets you specify individual pages (e.g., 1,3,5) or a range (e.g., 2-7) to print.

Question 12: In Excel, which function rounds a number DOWN to the nearest integer regardless of decimal value?

TRUNC
ROUND
INT (Correct answer)
CEILING

Correct answer: INT

The INT function rounds a number down to the nearest integer, always removing the decimal portion toward the lesser whole number.

Question 13: What does it mean when a file name appears with an asterisk (*) in the title bar of a Microsoft Office application?

The file contains macros
The file is currently being shared with other users
The file has unsaved changes (Correct answer)
The file is saved to the cloud

Correct answer: The file has unsaved changes

An asterisk in the title bar indicates there are unsaved changes in the current document.

Question 14: Which option in Microsoft Word allows users to add their favorite commands to a toolbar for quick access?

Navigation Pane
Task Manager
Quick Access Toolbar (Correct answer)
Status Bar

Correct answer: Quick Access Toolbar

The Quick Access Toolbar (QAT) in Microsoft Word is a customizable toolbar located above the Ribbon, designed for quick access to frequently used commands. Users can add their favorite commands, such as Save, Undo, Redo, or Print Preview, to this toolbar. This allows for personalized efficiency, as essential functions are always just one click away, regardless of the active Ribbon tab.

Question 15: In Excel, which feature allows you to create an interactive summary that groups and aggregates data from a larger dataset?

Pivot Table (Correct answer)
Named Range
Data Table
Outline

Correct answer: Pivot Table

A Pivot Table summarizes, groups, and aggregates large datasets interactively, letting you drag fields to reorganize the analysis.

Question 16: Which type of chart is most appropriate for displaying the percentage contribution of each category to a whole?

Pie chart (Correct answer)
Bubble chart
Line chart
Clustered column chart

Correct answer: Pie chart

Pie charts display each category as a slice of the whole circle, making proportions and percentages easy to visualize.

Question 17: In PowerPoint, which command on the Insert tab is used to add a spreadsheet-style grid for numeric data in a slide?

Chart
SmartArt
Table (Correct answer)
Spreadsheet Object

Correct answer: Table

Insert > Table adds a grid of rows and columns directly onto a PowerPoint slide for displaying structured data.

Question 18: In Microsoft Word, which feature allows you to perform simple calculations on numbers within a table?

AutoSum in Insert tab
Table Styles
Formula (Insert > Table Tools > Layout > Formula) (Correct answer)
Quick Tables

Correct answer: Formula (Insert > Table Tools > Layout > Formula)

The Formula option under Table Tools > Layout lets you insert formulas like =SUM(ABOVE) to calculate values in table cells.

Question 19: In Outlook, what does marking a message as 'High Importance' (the red exclamation mark) do?

Encrypts the email with a security certificate
Moves the message to the top of the recipient's inbox automatically
Requires the recipient to send a read receipt before they can close the email
Adds a red exclamation mark indicator in the recipient's inbox to signal that the message is urgent (Correct answer)

Correct answer: Adds a red exclamation mark indicator in the recipient's inbox to signal that the message is urgent

Marking a message as High Importance adds a visual red exclamation mark in the recipient's message list to alert them the message is urgent.

Question 20: Which Office application is best suited for managing email and calendars?

Microsoft Outlook (Correct answer)
Microsoft Access
Microsoft Publisher
Microsoft PowerPoint

Correct answer: Microsoft Outlook

Microsoft Outlook is the Microsoft Office application specifically designed and best suited for managing email, calendars, contacts, and tasks. It functions as a personal information manager, allowing users to send and receive emails, schedule appointments, organize meetings, and keep track of their professional and personal communications.

Question 21: Which Excel function is used to look up a value in the first column of a table and return a value in the same row from another column?

MATCH
HLOOKUP
INDEX
VLOOKUP (Correct answer)

Correct answer: VLOOKUP

VLOOKUP searches the first column of a range vertically and returns a value from a specified column in the same row.

Question 22: What tool allows collaborators to work on a presentation in real-time?

Spelling and Grammar
Co-authoring in PowerPoint (Correct answer)
Master Slide View
Header & Footer

Correct answer: Co-authoring in PowerPoint

Co-authoring in PowerPoint allows multiple users to work on the same presentation simultaneously and in real-time. When the presentation is stored in a cloud service like OneDrive or SharePoint, collaborators can see each other's changes as they happen. This feature significantly enhances team productivity and streamlines the creation and revision of presentations.

Question 23: Which security level in Office Trust Center completely blocks all macros with no user override?

Disable all macros with notification
Enable all macros
Disable all macros except digitally signed macros
Disable all macros without notification (Correct answer)

Correct answer: Disable all macros without notification

Disable all macros without notification silently blocks all macros and provides no way for the user to enable them.

Question 24: In Microsoft Office, what language are macros written in?

JavaScript
C#
Python
VBA (Visual Basic for Applications) (Correct answer)

Correct answer: VBA (Visual Basic for Applications)

Microsoft Office macros use VBA (Visual Basic for Applications) as their programming language.

Question 25: Which feature helps manage multiple document versions during collaborative work?

Clipboard
Version History (Correct answer)
Smart Lookup
AutoCorrect

Correct answer: Version History

Version History is a crucial feature, especially in collaborative environments, that automatically saves and tracks different versions of a document over time. It allows users to view previous iterations of a file, compare changes, and restore an earlier version if needed. This provides a safety net and helps manage complex document development cycles.

Question 26: In PowerPoint, how do you align multiple selected objects so their left edges line up?

Right-click > Group > Align Left
Drawing Tools > Format > Align > Align Left (Correct answer)
Home > Arrange > Align Left
Insert > Shapes > Align Left

Correct answer: Drawing Tools > Format > Align > Align Left

With multiple objects selected, the Align Left option under Drawing Tools > Format > Align lines up all selected objects' left edges.

Microsoft Certified Application Specialist (MCAS) Exam

The MCAS certification validates proficiency in using specific Microsoft Office applications, demonstrating essential skills for productivity in a professional environment.

Questions

50 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds