LATEST MICROSOFT OFFICE SPECIALIST:
EXCEL ASSOCIATE (EXCEL MICROSOFT
365 APPS) CERTIFICATION EXAM
OFFERED BY MICROSOFT | Q&A WITH
RATIONALES
1. Which keyboard shortcut creates a new, blank
workbook in Excel?
A) Ctrl + N
B) Ctrl + O
C) Ctrl + S
D) Ctrl + W
Correct answer: A
Rationale: Ctrl + N creates a new blank workbook.
Ctrl + O opens an existing workbook, Ctrl + S saves,
and Ctrl + W closes the active window.
2. What is the default file extension for an Excel
workbook saved in the standard format?
A) .xls
B) .xlsx
C) .csv
D) .xlsm
,Correct answer: B
Rationale: .xlsx is the default XML-based file format
for Excel workbooks starting with Excel 2007. .xls is
the older binary format, .csv is a text format, and
.xlsm is for macro-enabled workbooks.
3. Which view in Excel is best for seeing how a
worksheet will look when printed, including margins
and page breaks?
A) Normal view
B) Page Layout view
C) Page Break Preview
D) Custom Views
Correct answer: B
Rationale: Page Layout view displays the worksheet
as it will appear on the printed page, including
margins, headers, footers, and page breaks.
4. How can you freeze the top row of a worksheet so
it remains visible while scrolling?
A) View > Freeze Panes > Freeze Top Row
B) View > Freeze Panes > Freeze Panes
C) Window > Freeze Panes > Freeze Top Row
,D) Page Layout > Freeze Top Row
Correct answer: A
Rationale: Freeze Top Row is found under View >
Freeze Panes and keeps the top row visible while
scrolling.
5. Which command would you use to protect a
workbook's structure so that sheets cannot be
added, deleted, or renamed?
A) Review > Protect Sheet
B) Review > Protect Workbook
C) File > Info > Protect Workbook
D) Data > Protect Workbook
Correct answer: B
Rationale: Protect Workbook (under Review)
prevents changes to the workbook's structure, such
as adding, deleting, or renaming sheets.
6. When you share a workbook for co-authoring,
which feature allows multiple users to edit the same
file simultaneously?
A) Track Changes
B) Co-authoring
, C) Shared Workbooks (Legacy)
D) Compare and Merge Workbooks
Correct answer: B
Rationale: Co-authoring (available with files saved to
OneDrive or SharePoint) allows multiple users to edit
the same workbook simultaneously.
7. What does the "Document Inspector" do in Excel?
A) Checks for spelling and grammar errors
B) Removes hidden metadata and personal
information
C) Inspects the workbook for compatibility issues
D) Checks for broken links
Correct answer: B
Rationale: Document Inspector finds and removes
hidden metadata such as comments, document
properties, and other personal information before
sharing.
8. How can you move a worksheet from one
workbook to another?
A) Right-click the sheet tab and select Move or Copy
EXCEL ASSOCIATE (EXCEL MICROSOFT
365 APPS) CERTIFICATION EXAM
OFFERED BY MICROSOFT | Q&A WITH
RATIONALES
1. Which keyboard shortcut creates a new, blank
workbook in Excel?
A) Ctrl + N
B) Ctrl + O
C) Ctrl + S
D) Ctrl + W
Correct answer: A
Rationale: Ctrl + N creates a new blank workbook.
Ctrl + O opens an existing workbook, Ctrl + S saves,
and Ctrl + W closes the active window.
2. What is the default file extension for an Excel
workbook saved in the standard format?
A) .xls
B) .xlsx
C) .csv
D) .xlsm
,Correct answer: B
Rationale: .xlsx is the default XML-based file format
for Excel workbooks starting with Excel 2007. .xls is
the older binary format, .csv is a text format, and
.xlsm is for macro-enabled workbooks.
3. Which view in Excel is best for seeing how a
worksheet will look when printed, including margins
and page breaks?
A) Normal view
B) Page Layout view
C) Page Break Preview
D) Custom Views
Correct answer: B
Rationale: Page Layout view displays the worksheet
as it will appear on the printed page, including
margins, headers, footers, and page breaks.
4. How can you freeze the top row of a worksheet so
it remains visible while scrolling?
A) View > Freeze Panes > Freeze Top Row
B) View > Freeze Panes > Freeze Panes
C) Window > Freeze Panes > Freeze Top Row
,D) Page Layout > Freeze Top Row
Correct answer: A
Rationale: Freeze Top Row is found under View >
Freeze Panes and keeps the top row visible while
scrolling.
5. Which command would you use to protect a
workbook's structure so that sheets cannot be
added, deleted, or renamed?
A) Review > Protect Sheet
B) Review > Protect Workbook
C) File > Info > Protect Workbook
D) Data > Protect Workbook
Correct answer: B
Rationale: Protect Workbook (under Review)
prevents changes to the workbook's structure, such
as adding, deleting, or renaming sheets.
6. When you share a workbook for co-authoring,
which feature allows multiple users to edit the same
file simultaneously?
A) Track Changes
B) Co-authoring
, C) Shared Workbooks (Legacy)
D) Compare and Merge Workbooks
Correct answer: B
Rationale: Co-authoring (available with files saved to
OneDrive or SharePoint) allows multiple users to edit
the same workbook simultaneously.
7. What does the "Document Inspector" do in Excel?
A) Checks for spelling and grammar errors
B) Removes hidden metadata and personal
information
C) Inspects the workbook for compatibility issues
D) Checks for broken links
Correct answer: B
Rationale: Document Inspector finds and removes
hidden metadata such as comments, document
properties, and other personal information before
sharing.
8. How can you move a worksheet from one
workbook to another?
A) Right-click the sheet tab and select Move or Copy
