NEWEST MICROSOFT OFFICE
SPECIALIST (MOS) EXAM | Q&A
WITH RATIONALES
1. What is the default file extension for a
Microsoft Word 2019 document?
A. .doc
B. .docx
C. .txt
D. .dotx
Correct answer: B
Rationale: The default file extension for a Word
2019 document is .docx, which stands for Word
Open XML Document. .doc is the older format,
.txt is plain text, and .dotx is a template.
2. Which ribbon tab in Word contains the
command to insert a table of contents?
A. Home
B. Insert
,C. References
D. Review
Correct answer: C
Rationale: The References tab contains the
Table of Contents, Footnotes, Citations &
Bibliography, and other document reference
tools. The Insert tab is for adding objects like
pictures and tables, but the Table of Contents is
specifically under References.
3. In Microsoft Excel, which function is used to
find the largest value in a range of cells?
A. MAX
B. LARGE
C. HIGHEST
D. MAXIMUM
Correct answer: A
Rationale: The MAX function returns the largest
numeric value in a set of values. The LARGE
function returns the k-th largest value, not just
the maximum.
,4. What is the keyboard shortcut to save a file in
all Microsoft Office applications?
A. Ctrl + S
B. Ctrl + Shift + S
C. Ctrl + N
D. Alt + S
Correct answer: A
Rationale: Ctrl + S is the universal shortcut for
saving the current file in Microsoft Office
applications. Ctrl + N creates a new file, and Ctrl
+ Shift + S opens the Save As dialog.
5. Which view in PowerPoint displays all slides
as thumbnails for easy reordering?
A. Normal View
B. Slide Sorter View
C. Reading View
D. Outline View
Correct answer: B
, Rationale: Slide Sorter View shows all slides as
thumbnails, allowing users to click and drag
slides to reorder, add sections, and manage
transitions. Normal View is for editing individual
slides, Reading View is for presenting, and
Outline View shows text content.
6. In Microsoft Word, what is the purpose of the
"Mail Merge" feature?
A. To send individual emails to multiple
recipients
B. To create personalized letters, envelopes, or
labels for multiple recipients
C. To merge multiple documents into one
D. To combine Excel data with a PowerPoint
presentation
Correct answer: B
Rationale: Mail Merge is used to create
personalized documents, such as form letters,
envelopes, and labels, by combining a main
document with a data source like an Excel
spreadsheet or Access database.
SPECIALIST (MOS) EXAM | Q&A
WITH RATIONALES
1. What is the default file extension for a
Microsoft Word 2019 document?
A. .doc
B. .docx
C. .txt
D. .dotx
Correct answer: B
Rationale: The default file extension for a Word
2019 document is .docx, which stands for Word
Open XML Document. .doc is the older format,
.txt is plain text, and .dotx is a template.
2. Which ribbon tab in Word contains the
command to insert a table of contents?
A. Home
B. Insert
,C. References
D. Review
Correct answer: C
Rationale: The References tab contains the
Table of Contents, Footnotes, Citations &
Bibliography, and other document reference
tools. The Insert tab is for adding objects like
pictures and tables, but the Table of Contents is
specifically under References.
3. In Microsoft Excel, which function is used to
find the largest value in a range of cells?
A. MAX
B. LARGE
C. HIGHEST
D. MAXIMUM
Correct answer: A
Rationale: The MAX function returns the largest
numeric value in a set of values. The LARGE
function returns the k-th largest value, not just
the maximum.
,4. What is the keyboard shortcut to save a file in
all Microsoft Office applications?
A. Ctrl + S
B. Ctrl + Shift + S
C. Ctrl + N
D. Alt + S
Correct answer: A
Rationale: Ctrl + S is the universal shortcut for
saving the current file in Microsoft Office
applications. Ctrl + N creates a new file, and Ctrl
+ Shift + S opens the Save As dialog.
5. Which view in PowerPoint displays all slides
as thumbnails for easy reordering?
A. Normal View
B. Slide Sorter View
C. Reading View
D. Outline View
Correct answer: B
, Rationale: Slide Sorter View shows all slides as
thumbnails, allowing users to click and drag
slides to reorder, add sections, and manage
transitions. Normal View is for editing individual
slides, Reading View is for presenting, and
Outline View shows text content.
6. In Microsoft Word, what is the purpose of the
"Mail Merge" feature?
A. To send individual emails to multiple
recipients
B. To create personalized letters, envelopes, or
labels for multiple recipients
C. To merge multiple documents into one
D. To combine Excel data with a PowerPoint
presentation
Correct answer: B
Rationale: Mail Merge is used to create
personalized documents, such as form letters,
envelopes, and labels, by combining a main
document with a data source like an Excel
spreadsheet or Access database.
