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

Question 1: Which Microsoft Office application is commonly used to send emails with file attachments?

Microsoft Excel
Microsoft OneNote
Microsoft Access
Microsoft Outlook (Correct answer)

Correct answer: Microsoft Outlook

Microsoft Outlook is the primary Office application designed for managing emails, calendars, contacts, and tasks. It functions as an email client, allowing users to send, receive, and organize emails, often with the capability to attach files. Outlook is essential for professional communication and personal organization within the Microsoft ecosystem.

Question 2: Which feature tracks all changes made to a Word document by different users?

Spell Check
Track Changes (Correct answer)
Clipboard
AutoFormat

Correct answer: Track Changes

Track Changes is a powerful review feature in Microsoft Word that records every edit made to a document, including insertions, deletions, and formatting changes, by different users. These changes are displayed as suggestions, allowing the document owner to review, accept, or reject each modification. This is indispensable for collaborative editing and maintaining a clear revision history.

Question 3: In PowerPoint, which feature allows you to set up a presentation to run continuously and automatically advance slides at set intervals without a presenter?

Set Up Show > Browsed at a Kiosk (Loop Continuously) (Correct answer)
Slide Sorter > Auto Advance
Animation Pane > Auto Play
Rehearse Timings

Correct answer: Set Up Show > Browsed at a Kiosk (Loop Continuously)

The 'Browsed at a Kiosk' option under Set Up Show loops the presentation continuously and prevents manual navigation, ideal for self-running displays.

Question 4: In Microsoft Word, how do you insert a table with a specific number of rows and columns?

Page Layout > Columns > More Columns
Insert tab > Table > Insert Table (specify rows and columns) (Correct answer)
Home tab > Styles > Table
View > Table Options

Correct answer: Insert tab > Table > Insert Table (specify rows and columns)

The Insert tab contains the Table command where you can use 'Insert Table' to specify exact row and column counts.

Question 5: Which application is typically used for creating spreadsheets in Microsoft Office?

Microsoft Word
Microsoft Outlook
Microsoft Excel (Correct answer)
Microsoft Access

Correct answer: Microsoft Excel

Microsoft Excel is the dedicated application within the Microsoft Office suite specifically designed for creating and managing spreadsheets. It provides a powerful grid-based interface for organizing data, performing complex calculations, and generating charts and graphs for analysis. Its core functionality revolves around numerical data manipulation and presentation.

Question 6: Which Microsoft Office feature lets you open recently accessed files quickly without browsing to their folder?

Pin to Taskbar
Quick Launch toolbar
Recent Documents list (Correct answer)
Favorites folder

Correct answer: Recent Documents list

The Recent Documents list in the File menu displays files you have recently opened for quick access.

Question 7: Which feature lets you create and save a custom document template for future use?

Track Changes
Print Preview
Insert Caption
Save as Template (Correct answer)

Correct answer: Save as Template

When you create a document that you want to reuse as a starting point for future documents, the "Save as Template" feature is used. This option saves the document's structure, formatting, and any pre-filled content as a template file. It allows users to quickly create new documents based on that established design without altering the original template.

Question 8: In Excel, what is the difference between COUNT and COUNTA?

COUNT counts only numeric cells; COUNTA counts all non-empty cells regardless of type (Correct answer)
COUNT sums values; COUNTA finds averages
COUNT includes blank cells; COUNTA excludes blank cells
COUNT counts visible cells; COUNTA counts all cells including hidden rows

Correct answer: COUNT counts only numeric cells; COUNTA counts all non-empty cells regardless of type

COUNT only tallies cells containing numbers, while COUNTA counts any non-empty cell including text, dates, and numbers.

Question 9: What is the result of the Excel formula =SUM(A1:A5) if cells A1 through A5 contain the values 2, 4, 6, 8, and 10?

20
48
30 (Correct answer)
10

Correct answer: 30

SUM adds all values in the range: 2+4+6+8+10 = 30.

Question 10: In Microsoft Excel, which chart type is best suited for showing trends over time with continuous data?

Pie chart
Scatter chart
Line chart (Correct answer)
Bar chart

Correct answer: Line chart

Line charts are ideal for displaying trends over continuous time periods because the connected points show the direction of change.

Question 11: In PowerPoint, what is the purpose of the 'Rehearse Timings' feature?

It checks the presentation against a time limit and removes slides if it is too long
It records how long you spend on each slide during a rehearsal so timings can be saved for an automated show (Correct answer)
It generates automatic speaker notes based on rehearsal duration
It automatically syncs slide transitions to background music

Correct answer: It records how long you spend on each slide during a rehearsal so timings can be saved for an automated show

Rehearse Timings records the time you spend on each slide as you practice, then saves those timings to automate slide advancement during the real presentation.

Question 12: Which feature in Microsoft Office lets you preview how a document will look when printed?

Clipboard
Print Preview (Correct answer)
Track Changes
Page Break

Correct answer: Print Preview

Print Preview is a valuable feature that displays exactly how a document will appear when printed, before committing to the printing process. This allows users to check page breaks, margins, formatting, and overall layout. By using Print Preview, you can identify and correct any potential issues, saving paper and ink.

Question 13: What does the AutoRecover feature in Microsoft Office applications do?

Periodically saves a temporary copy of your file to recover after a crash (Correct answer)
Automatically emails your file to a backup address
Restores deleted files from the Recycle Bin
Automatically compresses large files

Correct answer: Periodically saves a temporary copy of your file to recover after a crash

AutoRecover periodically saves temporary copies of open files so work can be recovered if the application crashes.

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

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

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 15: Which menu option allows users to manage add-ins and extensions in Microsoft Office applications?

View Tab
Review Tab
Help Menu
Options → Add-ins (Correct answer)

Correct answer: Options → Add-ins

In Microsoft Office applications, the "Options" menu (often found under the File tab) provides access to various application settings. Within the Options dialog, the "Add-ins" section is specifically designed for users to view, enable, disable, or remove add-ins and extensions. These add-ins integrate with the Office application, enhancing its functionality.

Question 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 (Correct answer)
The document is shared with other users
The document is protected and cannot be edited
The spell check is currently disabled

Correct answer: The file was created in an older version of Word and some features may be disabled

Compatibility Mode indicates the document was created in an older Word format, limiting access to newer Word features.

Question 17: In Excel, what is the purpose of a secondary axis in a chart?

To add a second title to the chart
To plot a data series with a different scale on the right side of the chart (Correct answer)
To create a second chart on the same sheet
To show negative values below the x-axis

Correct answer: To plot a data series with a different scale on the right side of the chart

A secondary axis allows you to plot a data series using a separate scale on the right side, useful when series have vastly different value ranges.

Question 18: In Microsoft Excel, which symbol must begin every formula?

+
@
#
= (Correct answer)

Correct answer: =

Every Excel formula must begin with an equal sign (=) to signal that what follows is a calculation, not plain text.

Question 19: In Microsoft Word, which feature allows you to insert a reusable block of text or graphics that is stored and accessed quickly?

Clipboard
Quick Parts (AutoText) (Correct answer)
Smart Art
Styles Gallery

Correct answer: Quick Parts (AutoText)

Quick Parts (including AutoText) stores reusable content blocks that can be quickly inserted into documents.

Question 20: In Microsoft Word, how do you merge two or more cells in a table into a single cell?

Use Format > Table > Combine Cells
Select the cells, then use Table Tools > Layout > Merge Cells (Correct answer)
Select the cells, then use Table Tools > Design > Merge
Right-click a single cell and choose Expand Cell

Correct answer: Select the cells, then use Table Tools > Layout > Merge Cells

The Merge Cells button is located in the Table Tools > Layout tab after selecting the cells you wish to combine.

Question 21: What is the purpose of comments in Microsoft Office documents?

Create charts
Insert hyperlinks
Leave feedback or notes on document content (Correct answer)
Adjust margins

Correct answer: Leave feedback or notes on document content

Comments in Microsoft Office documents serve as a valuable tool for leaving feedback, asking questions, or making notes about specific content without altering the main text. They appear as annotations alongside the document, allowing collaborators to engage in discussions and provide context-specific input. This enhances communication and streamlines the review process.

Question 22: What is the keyboard shortcut to open the Macro dialog box in Excel?

Ctrl + Shift + M
Alt + F11
Alt + F8 (Correct answer)
Ctrl + M

Correct answer: Alt + F8

Alt + F8 opens the Macro dialog box, where you can run, edit, or delete macros.

Question 23: Which command is used to apply bold formatting to selected text?

Ctrl + U
Ctrl + I
Ctrl + P
Ctrl + B (Correct answer)

Correct answer: Ctrl + B

The keyboard shortcut 'Ctrl + B' is universally recognized in Microsoft Office applications to apply or remove bold formatting from selected text. This command toggles the bold attribute, making it a quick and efficient way to emphasize specific words or phrases. It's a fundamental shortcut for text styling.

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

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

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 25: Which feature helps manage multiple document versions during collaborative work?

Smart Lookup
Version History (Correct answer)
AutoCorrect
Clipboard

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 Microsoft Word, which feature allows you to perform simple calculations on numbers within a table?

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

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.

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