,TESTBANK FOR Exploring Microsoft 365 Excel 2025,
1st edition Mary Anne Poatsy
Notes
1- The file is chapter after chapter.
2- We have shown you few pages sample.
3- The file contains all Appendix and Excel sheet
if it exists.
4- We have all what you need, we make update
at every time. There are many new editions
waiting you.
5- If you think you purchased the wrong file You
can contact us at every time, we can replace it
with true one.
Our email:
,Exploring Microsoft Office 365: Excel 2025 (Poatsy)
Microsoft 365 Common Features
1) Which of the following Microsoft 365 applications is used to produce documents, including
memos, newsletters, forms, brochures?
A) Access
B) Excel
C) Word
D) PowerPoint
Answer: C
Diff: 1
Objective: CF1.01 Work with Files
2) Which of the following Microsoft 365 applications is used to create dynamic presentations to
inform and persuade audiences?
A) Access
B) Word
C) PowerPoint
D) Excel
Answer: C
Diff: 1
Objective: CF1.01 Work with Files
3) Which of the following Microsoft 365 applications is a database software application that is
used to record and link data, query databases, and create forms and reports?
A) Access
B) Word
C) PowerPoint
D) Excel
Answer: A
Diff: 2
Objective: CF1.01 Work with Files
4) When using Microsoft 365, the AutoSave location for saving files is ________.
A) Dropbox
B) Google Drive
C) OneDrive
D) iCloud
Answer: C
Diff: 3
Objective: CF1.01 Work with Files
1
Copyright © 2026 Pearson Education, Inc.
,5) The ________ contains the current file name and the application in which you are working.
A) title bar
B) status bar
C) Quick Access Toolbar
D) ribbon
Answer: A
Diff: 2
Objective: CF1.02 Use Common Interface Components
6) The ________ is the command center of the Microsoft 365 application containing tabs,
groups, and commands.
A) title bar
B) Mini Toolbar
C) ribbon
D) status bar
Answer: C
Diff: 2
Objective: CF1.02 Use Common Interface Components
7) The ________ provides a customizable option for commonly executed tasks such as save or
undo.
A) Quick Access Toolbar
B) ribbon
C) title bar
D) tab
Answer: A
Diff: 1
Objective: CF1.02 Use Common Interface Components
8) A(n) ________ contains groups of commands related to a selected object.
A) ribbon
B) contextual tab
C) status bar
D) title bar
Answer: B
Diff: 2
Objective: CF1.02 Use Common Interface Components
9) A(n) ________ is used to organize similar tasks together on a tab.
A) group
B) contextual tab
C) title bar
D) command
Answer: A
Diff: 2
Objective: CF1.02 Use Common Interface Components
2
Copyright © 2026 Pearson Education, Inc.
,10) Less commonly used commands and features can be found in a(n) ________.
A) tab
B) group
C) gallery
D) dialog box
Answer: D
Diff: 3
Objective: CF1.02 Use Common Interface Components
11) Depending on the application, a(n) ________ is an area that provides additional text styles,
choices of chart styles, or transitions.
A) command
B) gallery
C) tab
D) template
Answer: B
Diff: 2
Objective: CF1.02 Use Common Interface Components
12) ________ is located on the title bar and can be used to recall recently used commands, find
help and information about a command or task, or locate a specific Action.
A) Help
B) Keyboard shortcuts
C) ScreenTip
D) Search
Answer: D
Diff: 2
Objective: CF1.02 Use Common Interface Components
13) Which of the following is a context-sensitive menu that displays commands and options
relevant to an active object?
A) Live Preview
B) Shortcut menu
C) Dialog box
D) Gallery
Answer: B
Diff: 2
Objective: CF1.02 Use Common Interface Components
3
Copyright © 2026 Pearson Education, Inc.
,14) A(n) ________ is a small message box that displays when the pointer is hovered over a
command button.
A) Live Preview
B) shortcut menu
C) gallery
D) ScreenTip
Answer: D
Diff: 2
Objective: CF1.02 Use Common Interface Components
15) A(n) ________ is used to copy all applied formatting from one set of text to another.
A) ScreenTip
B) keyboard shortcuts
C) Format Painter
D) Live Preview
Answer: C
Diff: 2
Objective: CF1.02 Use Common Interface Components
16) Which of the following is a collection of design elements that includes colors, fonts, and
special effects used to give a consistent look to your work?
A) Template
B) Theme
C) Format Painter
D) Gallery
Answer: B
Diff: 2
Objective: CF1.03 Use Templates and Apply Themes
17) A(n) ________ is a predesigned file that incorporates formatting elements and may include
content that can be modified.
A) template
B) theme
C) command
D) gallery
Answer: A
Diff: 2
Objective: CF1.03 Use Templates and Apply Themes
18) Some formatting, such as Bold and Italic, that can be turned on and off are called ________.
A) toggle commands
B) templates
C) themes
D) groups
Answer: A
Diff: 3
Objective: CF1.04 Modify, Relocate, and Review Text
4
Copyright © 2026 Pearson Education, Inc.
,19) The ________ gives you access to the most common formatting selections, such as adding
bold or italic, or changing font type or color.
A) ScreenTip
B) Format Painter
C) Dialog Box Launcher
D) Mini Toolbar
Answer: D
Diff: 2
Objective: CF1.04 Modify, Relocate, and Review Text
20) The ________ is an area of memory reserved to temporarily hold selections that have been
cut or copied.
A) gallery
B) Clipboard
C) contextual tab
D) ribbon
Answer: B
Diff: 2
Objective: CF1.04 Modify, Relocate, and Review Text
21) Which of the following means to remove a selection from the original location and place it in
the Clipboard?
A) Select
B) Paste
C) Copy
D) Cut
Answer: D
Diff: 1
Objective: CF1.04 Modify, Relocate, and Review Text
22) Which Microsoft 365 application does not check spelling as you enter text?
A) Excel
B) Word
C) Access
D) PowerPoint
Answer: A
Diff: 2
Objective: CF1.04 Modify, Relocate, and Review Text
5
Copyright © 2026 Pearson Education, Inc.
,23) A(n) ________ is a digital photo.
A) shape
B) icon
C) picture
D) chart
Answer: C
Diff: 1
Objective: CF1.05 Work with Pictures
24) In order to maintain proper proportions to a picture when adjusting its size, you must use the
________ sizing handle.
A) center edge
B) left or right
C) top or bottom
D) corner
Answer: D
Diff: 2
Objective: CF1.05 Work with Pictures
25) The ________ is located at the bottom of the screen and displays information relevant to the
application and file.
A) title bar
B) contextual tab
C) status bar
D) Quick Access Toolbar
Answer: C
Diff: 2
Objective: CF1.06 Change File Views
26) A(n) ________ is the area of blank space that displays around the edge of a document.
A) margin
B) header
C) footer
D) border
Answer: A
Diff: 1
Objective: CF1.07 Change the Page Layout
27) A(n) ________ is a section in the top margin of a file.
A) footer
B) header
C) endnote
D) footnote
Answer: B
Diff: 1
Objective: CF1.07 Change the Page Layout
6
Copyright © 2026 Pearson Education, Inc.
,28) A(n) ________ is a section in the bottom margin of a file.
A) header
B) endnote
C) footnote
D) footer
Answer: D
Diff: 1
Objective: CF1.07 Change the Page Layout
29) Which of the following is a data element that is added as a document property?
A) picture
B) tag
C) footer
D) header
Answer: B
Diff: 2
Objective: CF1.08 Configure File Properties and Print a File
30) File properties can be found on which page on the File tab?
A) Info
B) Print
C) Save
D) Share
Answer: A
Diff: 3
Objective: CF1.08 Configure File Properties and Print a File
31) You can use Excel to organize records, financial transactions, and business information in
the form of worksheets.
Answer: TRUE
Diff: 1
Objective: CF1.01 Work with Files
32) The ribbon identifies the current file name and the application in which you are working.
Answer: FALSE
Diff: 2
Objective: CF1.02 Use Common Interface Components
33) A contextual tab is a button or icon within a group that you click to perform a task.
Answer: FALSE
Diff: 2
Objective: CF1.02 Use Common Interface Components
7
Copyright © 2026 Pearson Education, Inc.
, 34) The Quick Access Toolbar provides one-click access to commonly executed tasks such as
saving a file or undoing recent actions.
Answer: TRUE
Diff: 2
Objective: CF1.02 Use Common Interface Components
35) Additional formatting and design options are found in the gallery.
Answer: TRUE
Diff: 1
Objective: CF1.02 Use Common Interface Components
36) A ScreenTip box enables you to search for help and information about a command or task.
Answer: FALSE
Diff: 2
Objective: CF1.02 Use Common Interface Components
37) A template is a collection of design choices that includes colors, fonts, and special effects
used to give a consistent look to your work.
Answer: FALSE
Diff: 2
Objective: CF1.03 Use Templates and Apply Themes
38) A theme is a predesigned file that incorporates formatting elements, such as layouts and may
include content that can be modified.
Answer: FALSE
Diff: 2
Objective: CF1.03 Use Templates and Apply Themes
39) Bold and Italic are examples of toggle commands.
Answer: TRUE
Diff: 2
Objective: CF1.04 Modify, Relocate, and Review Text
40) The Mini Toolbar provides access to the most common formatting selections.
Answer: TRUE
Diff: 2
Objective: CF1.04 Modify, Relocate, and Review Text
41) The Clipboard is an area of memory that is used to temporarily hold selections that you have
cut or copied, and it allows you to paste the selections.
Answer: TRUE
Diff: 1
Objective: CF1.04 Modify, Relocate, and Review Text
8
Copyright © 2026 Pearson Education, Inc.
1st edition Mary Anne Poatsy
Notes
1- The file is chapter after chapter.
2- We have shown you few pages sample.
3- The file contains all Appendix and Excel sheet
if it exists.
4- We have all what you need, we make update
at every time. There are many new editions
waiting you.
5- If you think you purchased the wrong file You
can contact us at every time, we can replace it
with true one.
Our email:
,Exploring Microsoft Office 365: Excel 2025 (Poatsy)
Microsoft 365 Common Features
1) Which of the following Microsoft 365 applications is used to produce documents, including
memos, newsletters, forms, brochures?
A) Access
B) Excel
C) Word
D) PowerPoint
Answer: C
Diff: 1
Objective: CF1.01 Work with Files
2) Which of the following Microsoft 365 applications is used to create dynamic presentations to
inform and persuade audiences?
A) Access
B) Word
C) PowerPoint
D) Excel
Answer: C
Diff: 1
Objective: CF1.01 Work with Files
3) Which of the following Microsoft 365 applications is a database software application that is
used to record and link data, query databases, and create forms and reports?
A) Access
B) Word
C) PowerPoint
D) Excel
Answer: A
Diff: 2
Objective: CF1.01 Work with Files
4) When using Microsoft 365, the AutoSave location for saving files is ________.
A) Dropbox
B) Google Drive
C) OneDrive
D) iCloud
Answer: C
Diff: 3
Objective: CF1.01 Work with Files
1
Copyright © 2026 Pearson Education, Inc.
,5) The ________ contains the current file name and the application in which you are working.
A) title bar
B) status bar
C) Quick Access Toolbar
D) ribbon
Answer: A
Diff: 2
Objective: CF1.02 Use Common Interface Components
6) The ________ is the command center of the Microsoft 365 application containing tabs,
groups, and commands.
A) title bar
B) Mini Toolbar
C) ribbon
D) status bar
Answer: C
Diff: 2
Objective: CF1.02 Use Common Interface Components
7) The ________ provides a customizable option for commonly executed tasks such as save or
undo.
A) Quick Access Toolbar
B) ribbon
C) title bar
D) tab
Answer: A
Diff: 1
Objective: CF1.02 Use Common Interface Components
8) A(n) ________ contains groups of commands related to a selected object.
A) ribbon
B) contextual tab
C) status bar
D) title bar
Answer: B
Diff: 2
Objective: CF1.02 Use Common Interface Components
9) A(n) ________ is used to organize similar tasks together on a tab.
A) group
B) contextual tab
C) title bar
D) command
Answer: A
Diff: 2
Objective: CF1.02 Use Common Interface Components
2
Copyright © 2026 Pearson Education, Inc.
,10) Less commonly used commands and features can be found in a(n) ________.
A) tab
B) group
C) gallery
D) dialog box
Answer: D
Diff: 3
Objective: CF1.02 Use Common Interface Components
11) Depending on the application, a(n) ________ is an area that provides additional text styles,
choices of chart styles, or transitions.
A) command
B) gallery
C) tab
D) template
Answer: B
Diff: 2
Objective: CF1.02 Use Common Interface Components
12) ________ is located on the title bar and can be used to recall recently used commands, find
help and information about a command or task, or locate a specific Action.
A) Help
B) Keyboard shortcuts
C) ScreenTip
D) Search
Answer: D
Diff: 2
Objective: CF1.02 Use Common Interface Components
13) Which of the following is a context-sensitive menu that displays commands and options
relevant to an active object?
A) Live Preview
B) Shortcut menu
C) Dialog box
D) Gallery
Answer: B
Diff: 2
Objective: CF1.02 Use Common Interface Components
3
Copyright © 2026 Pearson Education, Inc.
,14) A(n) ________ is a small message box that displays when the pointer is hovered over a
command button.
A) Live Preview
B) shortcut menu
C) gallery
D) ScreenTip
Answer: D
Diff: 2
Objective: CF1.02 Use Common Interface Components
15) A(n) ________ is used to copy all applied formatting from one set of text to another.
A) ScreenTip
B) keyboard shortcuts
C) Format Painter
D) Live Preview
Answer: C
Diff: 2
Objective: CF1.02 Use Common Interface Components
16) Which of the following is a collection of design elements that includes colors, fonts, and
special effects used to give a consistent look to your work?
A) Template
B) Theme
C) Format Painter
D) Gallery
Answer: B
Diff: 2
Objective: CF1.03 Use Templates and Apply Themes
17) A(n) ________ is a predesigned file that incorporates formatting elements and may include
content that can be modified.
A) template
B) theme
C) command
D) gallery
Answer: A
Diff: 2
Objective: CF1.03 Use Templates and Apply Themes
18) Some formatting, such as Bold and Italic, that can be turned on and off are called ________.
A) toggle commands
B) templates
C) themes
D) groups
Answer: A
Diff: 3
Objective: CF1.04 Modify, Relocate, and Review Text
4
Copyright © 2026 Pearson Education, Inc.
,19) The ________ gives you access to the most common formatting selections, such as adding
bold or italic, or changing font type or color.
A) ScreenTip
B) Format Painter
C) Dialog Box Launcher
D) Mini Toolbar
Answer: D
Diff: 2
Objective: CF1.04 Modify, Relocate, and Review Text
20) The ________ is an area of memory reserved to temporarily hold selections that have been
cut or copied.
A) gallery
B) Clipboard
C) contextual tab
D) ribbon
Answer: B
Diff: 2
Objective: CF1.04 Modify, Relocate, and Review Text
21) Which of the following means to remove a selection from the original location and place it in
the Clipboard?
A) Select
B) Paste
C) Copy
D) Cut
Answer: D
Diff: 1
Objective: CF1.04 Modify, Relocate, and Review Text
22) Which Microsoft 365 application does not check spelling as you enter text?
A) Excel
B) Word
C) Access
D) PowerPoint
Answer: A
Diff: 2
Objective: CF1.04 Modify, Relocate, and Review Text
5
Copyright © 2026 Pearson Education, Inc.
,23) A(n) ________ is a digital photo.
A) shape
B) icon
C) picture
D) chart
Answer: C
Diff: 1
Objective: CF1.05 Work with Pictures
24) In order to maintain proper proportions to a picture when adjusting its size, you must use the
________ sizing handle.
A) center edge
B) left or right
C) top or bottom
D) corner
Answer: D
Diff: 2
Objective: CF1.05 Work with Pictures
25) The ________ is located at the bottom of the screen and displays information relevant to the
application and file.
A) title bar
B) contextual tab
C) status bar
D) Quick Access Toolbar
Answer: C
Diff: 2
Objective: CF1.06 Change File Views
26) A(n) ________ is the area of blank space that displays around the edge of a document.
A) margin
B) header
C) footer
D) border
Answer: A
Diff: 1
Objective: CF1.07 Change the Page Layout
27) A(n) ________ is a section in the top margin of a file.
A) footer
B) header
C) endnote
D) footnote
Answer: B
Diff: 1
Objective: CF1.07 Change the Page Layout
6
Copyright © 2026 Pearson Education, Inc.
,28) A(n) ________ is a section in the bottom margin of a file.
A) header
B) endnote
C) footnote
D) footer
Answer: D
Diff: 1
Objective: CF1.07 Change the Page Layout
29) Which of the following is a data element that is added as a document property?
A) picture
B) tag
C) footer
D) header
Answer: B
Diff: 2
Objective: CF1.08 Configure File Properties and Print a File
30) File properties can be found on which page on the File tab?
A) Info
B) Print
C) Save
D) Share
Answer: A
Diff: 3
Objective: CF1.08 Configure File Properties and Print a File
31) You can use Excel to organize records, financial transactions, and business information in
the form of worksheets.
Answer: TRUE
Diff: 1
Objective: CF1.01 Work with Files
32) The ribbon identifies the current file name and the application in which you are working.
Answer: FALSE
Diff: 2
Objective: CF1.02 Use Common Interface Components
33) A contextual tab is a button or icon within a group that you click to perform a task.
Answer: FALSE
Diff: 2
Objective: CF1.02 Use Common Interface Components
7
Copyright © 2026 Pearson Education, Inc.
, 34) The Quick Access Toolbar provides one-click access to commonly executed tasks such as
saving a file or undoing recent actions.
Answer: TRUE
Diff: 2
Objective: CF1.02 Use Common Interface Components
35) Additional formatting and design options are found in the gallery.
Answer: TRUE
Diff: 1
Objective: CF1.02 Use Common Interface Components
36) A ScreenTip box enables you to search for help and information about a command or task.
Answer: FALSE
Diff: 2
Objective: CF1.02 Use Common Interface Components
37) A template is a collection of design choices that includes colors, fonts, and special effects
used to give a consistent look to your work.
Answer: FALSE
Diff: 2
Objective: CF1.03 Use Templates and Apply Themes
38) A theme is a predesigned file that incorporates formatting elements, such as layouts and may
include content that can be modified.
Answer: FALSE
Diff: 2
Objective: CF1.03 Use Templates and Apply Themes
39) Bold and Italic are examples of toggle commands.
Answer: TRUE
Diff: 2
Objective: CF1.04 Modify, Relocate, and Review Text
40) The Mini Toolbar provides access to the most common formatting selections.
Answer: TRUE
Diff: 2
Objective: CF1.04 Modify, Relocate, and Review Text
41) The Clipboard is an area of memory that is used to temporarily hold selections that you have
cut or copied, and it allows you to paste the selections.
Answer: TRUE
Diff: 1
Objective: CF1.04 Modify, Relocate, and Review Text
8
Copyright © 2026 Pearson Education, Inc.
