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

Question 1: In Excel, what is the difference between 'Close' and 'Exit'?

Exit closes the current workbook; Close closes Excel entirely
Close closes the current workbook but keeps Excel open; Exit closes Excel entirely (Correct answer)
Close saves the file; Exit discards changes
There is no difference; they do the same thing

Correct answer: Close closes the current workbook but keeps Excel open; Exit closes Excel entirely

Close closes only the active workbook while keeping the Excel application running, whereas Exit closes the entire Excel application.

Question 2: In Microsoft Office, what is the purpose of the 'Document Properties' panel?

To track changes made to the document
To view and edit metadata such as author, title, and keywords (Correct answer)
To set page margins and orientation
To change the document font settings

Correct answer: To view and edit metadata such as author, title, and keywords

Document Properties stores metadata about the file including author name, title, subject, and keywords.

Question 3: In Excel, which function returns the number of characters in a text string?

CHARS
SIZE
LEN (Correct answer)
COUNT

Correct answer: LEN

The LEN function returns the total number of characters (including spaces) in a text string.

Question 4: Where do you change how many files appear in the Recent Documents list in Word 2007?

Save > AutoRecover
Proofing > AutoCorrect
Popular > Top options
Advanced > Display (Correct answer)

Correct answer: Advanced > Display

The Display section of the Advanced category sets the number of documents in the Recent Documents list.

Question 5: When you resize a table in Microsoft Word by dragging a column border, what changes?

All columns automatically equalize their widths
Only the width of the selected column changes (Correct answer)
The text font size inside the column adjusts automatically
The entire table is scaled proportionally

Correct answer: Only the width of the selected column changes

Dragging a column border in Word adjusts only that specific column's width, which may affect adjacent column widths depending on settings.

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

Paragraph Styles
Office Theme (Correct answer)
Gridlines
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 7: In Excel, how can you let a colleague see your changes in a shared workbook with the Highlight Changes feature on?

The workbook is emailed automatically
The sheet turns read-only
All formulas are displayed
Changes are highlighted with a colored border and comment indicator (Correct answer)

Correct answer: Changes are highlighted with a colored border and comment indicator

Highlight Changes marks edited cells with a border and a tooltip showing who changed them and when.

Question 8: In PowerPoint, what is the purpose of 'Animation' as distinct from 'Transitions'?

Animations apply effects to individual objects on a slide; Transitions control how slides change from one to the next (Correct answer)
Animations are for images only; Transitions are for text only
Animations control how slides enter the screen; Transitions control objects on slides
Animations require manual triggers; Transitions always run automatically

Correct answer: Animations apply effects to individual objects on a slide; Transitions control how slides change from one to the next

Animations are applied to individual objects (text, images, shapes) on a slide, while transitions are effects applied to the whole slide when moving between slides.

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

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

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 10: Which Office file format is the default for saving a Word document in modern versions?

.docx (Correct answer)
.rtf
.dotx
.doc

Correct answer: .docx

Word 2007 and later save documents as .docx by default.

Question 11: What feature in Microsoft Word allows users to change the appearance of text, such as font size and color?

Review tab
Font group (Correct answer)
Insert tab
Mailings tab

Correct answer: Font group

The 'Font' group, typically found on the Home tab in Microsoft Word, contains all the essential tools for modifying text appearance. Users can change the font type, size, color, apply bold, italic, or underline formatting, and adjust other text attributes. This group provides comprehensive control over the visual style of text within a document.

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

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

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 13: What does the AutoRecover feature in Microsoft Office applications do?

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

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: In Excel, what does the IF function do?

Rounds a number to a specified number of decimal places
Looks up a value in a table and returns a result from the same row
Returns one value if a condition is true and another value if it is false (Correct answer)
Counts the number of cells that are not empty

Correct answer: Returns one value if a condition is true and another value if it is false

The IF function evaluates a logical condition and returns one value for TRUE and a different value for FALSE.

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

XLSM
XLS
CSV (Correct answer)
XLSX

Correct answer: CSV

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

Question 16: In Excel, what happens when you choose File > Share > Email > Send as PDF?

The workbook is stored in the recycle bin
Formulas are converted to values in the original file
The workbook is password protected
A PDF copy of the workbook is attached to a new email message (Correct answer)

Correct answer: A PDF copy of the workbook is attached to a new email message

Send as PDF attaches a fixed-layout PDF version to an Outlook message.

Question 17: In PowerPoint, which feature would you use to represent organizational hierarchy visually?

SmartArt Hierarchy diagram (Correct answer)
WordArt
Chart > Bar
Linked Excel table

Correct answer: SmartArt Hierarchy diagram

SmartArt Hierarchy diagrams are designed specifically to show organizational structures and reporting relationships.

Question 18: Which command is used to insert a table into a Word document?

Insert → Table (Correct answer)
View → Ruler
Review → Word Count
Layout → Breaks

Correct answer: Insert → Table

To insert a table into a Word document, the correct command sequence is typically 'Insert' tab, then selecting 'Table'. This action opens options to define the number of rows and columns, or to draw a custom table. The Insert tab is dedicated to adding various elements like pictures, shapes, and tables to a document.

Question 19: What does a digital signature added to an Office document verify?

That all comments were resolved
The author's identity and that the content has not been altered (Correct answer)
That the document is free of spelling errors
That the file is compatible with older versions

Correct answer: The author's identity and that the content has not been altered

Digital signatures authenticate the signer and detect later modifications.

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

To create a second chart on the same sheet
To plot a data series with a different scale on the right side of the chart (Correct answer)
To add a second title to the chart
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 21: In PowerPoint, how do you add a new slide with a specific layout (e.g., Two Content)?

Design > Slide Size > New Layout
View > Layout > Add Slide
Home > New Slide > (select layout from dropdown) (Correct answer)
Insert > Slide > Layout Picker

Correct answer: Home > New Slide > (select layout from dropdown)

The Home tab's 'New Slide' dropdown arrow expands to show all available slide layouts so you can pick the right one.

Question 22: In Microsoft Word, which option lets you sort the rows of a table alphabetically based on a specific column?

Home > Sort & Filter
Insert > Sort Table
Table Tools > Design > Sort
Table Tools > Layout > Sort (Correct answer)

Correct answer: Table Tools > Layout > Sort

The Sort button in Table Tools > Layout allows you to sort table rows alphabetically or numerically by a chosen column.

Question 23: In PowerPoint, how do you group multiple objects so they move and resize together?

Select all objects, then use Drawing Tools > Format > Group > Group (Correct answer)
Select all objects, then press Ctrl+M
Insert > Group Objects
Home > Arrange > Lock Position

Correct answer: Select all objects, then use Drawing Tools > Format > Group > Group

After selecting all the objects you want to group, use Drawing Tools > Format > Group > Group to combine them into a single grouped object.

Question 24: 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?

30 (Correct answer)
20
10
48

Correct answer: 30

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

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

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

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 26: How can you make a chosen font and size the default for all new blank Word documents?

Format Painter on the first paragraph
Apply the Heading 1 style
Save the document as a PDF
Open the Font dialog, choose the font, and click Set As Default (Correct answer)

Correct answer: Open the Font dialog, choose the font, and click Set As Default

Set As Default in the Font dialog stores the font in the Normal template for new documents.

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